SQL Excel

Hi Everyone,

I am trying to figure out what would be good to work on for the next release so posting up.
am thinking that some of the items below will be good.
- Add a button to halt execution of a query
- Format/beautify the SQL statements in the main form text box.
- add in a button to generate the ado/vb code equivalent for a SQL statement.

There were several other suggestions made and I need to go back and find them but this is a basic list to look at.

It would be good to know what people think would be good to add.

Thanks and see you, Al

Hi All

Was thinking tonight that another thing that might be worth doing would be to enable the add-in to work in other Microsoft office applications - Word, Outlook, Frontage, Access.

The embed query to worksheet functionality would have to be disbled but apart from that, the other functionalties should work fine. Would have to use the different object types for the pasting of the data (use Table in Word instead of Range etc.) but apart from there should not be too many changes.

Enabling the add-in to work within Microsoft Access might seem like a crazy idea at this point but I think that with later versions it could be a useful add-in to have.

Not sure if that is a good idea.. If anyone has an idea on that please post up.
Thanks, Al

Hi Al!

I think that's a great idea, even including it into Access, as the improvement over the standard query wizard is tremendous.

-regards,
Roland

Hi Roland

Thanks very much and for signing up site.. I see you posted up a good few messages.. Thanks a million for that. Great to get all the feedback.
Was up late last night and just got up. Have to rush out now to go into town.

I think you are right that it will be good to have in Access. So, say your are in Access but want to link to MYSQL or some other provider. If there is a way to embed the query into Access it will be great.

Very sorry, have to rush. Late already. Back later on, thanks, al