SQL Excel

Auto update - I don't see the option that i can rerun queries in Excel. Im not sure if this is missing, because i thought i saw it a few days ago. There can be several options:
* Rerun all queries when connecting
* Giving an option to run particular queries again in the SQL screen (so you need historie)
* Giving an option in the right-mouse click menu if you click in an Excel (most upleft cell?)


Secondly the syntax seems to be very very tight. I noticed this when i wanted to use "LIKE". I have to write it like "Like" and it is just very strict. Maybe for future releases you can make a more advanced SQL builder. Of course, the basics are available and i know this are more advanced functions. A helpfile with these things could also help (like a syntax guide).

And last but not least, this is really a good plugin. I certainly will follow it.

Now i had a second thought about it .
I think there is no "link" between the cells and the query. Its just a one time query to get information. So the right clicking won't be easy i guess.

Be best option would be a history of queries with the following things that should be logged:
Name - so you can give a name to it if you like
Cells - where it should be put
Query - the query that should be executed.
Collection - so you can execute a whole bunch of queries (1 collection) at once

If you can combine those things in some sort of collection, then you only have to click a few times to update. I don't think its easy to make it work out of VBA right?

Hi again Bliztoff ! Coming back for your other posts.

For the auto upgrade you got it exactly.

At the moment, it is not there and the addin just gives a one shot paste into Excel.

But we will be adding in the update procedure basically like you describe. Originally I was thinking of adding in
(1) the "auto" update so embed the query into an Excel worksheet like you can do from MS Query (Right click event should not be a problem here...)
(2) Have an extra button on the form to generate the ADO/VBA equvalent of the SELECT. This will give much more control as then it is possible to customize it exactly.

I did not think about it exactly like the way you described it but I really think the idea is awesome. If I got it right, it like an advanced version of point (1) above. We can have an extra form where we can configure the various queries (conection name, query, worksheet name, cell). We could store all this at the workbook level (maybe though named contants) and then just have an extra button to load up a view of what queries are available in a workbook (and modifiy them there if needed.)

Really great stuff !!!!

Thanks and back in a bit, Al

Well, that would definitely be a good point. Till now the plugin isn't really much more functionality than the standard SQL in Excel. Its more graphical, thats a plus. Auto-update will definitely be a great addition. I tell you why it is for me. I am working on some sort of dashboard or measurement model. If i have to update on 20-30 sheets manually, its a whole lot of work haha.

I hope it will work.

That is right. A few people have mentioned this. That, the add-in just does what MS Query does..
But I think it will be much better given time. It is a matter of taking it step by step a bit and this is kindof the first step.
Sorry for those 20 sheets !! That will keep you out of trouble for a while
Will try to get at least some of these extra you mentioned in fast..

Will be back when I have an update on them..

Thank you, AL