Run Sql Queries in excel against database using Macro

[Analabhatla]

Hello- I'm new to this forum and need help with following badly..

I have sql queries in spreadsheet column and which needs to run against Db2 database daily and then update the result back to spreadsheet. This is tedious process and could there be a way to create a a macro using VB which performs the following?

1. connect to db2 database
2. take the sql query one at a time from every row and then run against database
3. Obtain the result and then update it back to last column of the spreadsheet.

[JohnM3]

I don't have db2 - but this might jump start you - CODE NOT TESTED

Please Login or Register  to view this content.

[Analabhatla]

Thanks John. This is so much useful. I have started using this code and stuck with one problem. Basically i want to create a user form and then show the options to input user name, choose database, import spreadsheet which has sql and then submit . I have created the form and now i would like to show the form on first spreadsheet as static (i meant the form should be visible always like html page when the spreadsheet is opened ). i tried form.show option but it is not heping me. Any more ideas on this?

[JohnM3]

I'm NOT sure I can give you the BEST approach ..... (I don't work with forms alot)
but the following seems to work. It uses the Workbook_Open Event as follows:

Please Login or Register  to view this content.