SQL in VBA

[Sathish KV]

Hi All,

Thought of sharing something new!

What if you have a database in separate excel file and the data to be queried in separate excel file and output required in a separate excel file

Check out the attached file. The sql connection string mackes an ADODB connection to both data base and the 'To be queried' file then the result in brought to our current workbook

Just save all the three excels to from zip file to same folder.
Open the 'SQL in Excel VBA.xlsm' file and click the command button
You can also increase or decrease the data in 'Query Upload File.xlsx' to check the it works perfectly

Any queries welcome!

 

[Prasenjit Basumatary]

Hi @Sathish KV

I am replying here for some help. Would you please solve the problem of the following link:

http://chandoo.org/forum/threads/da...-results-with-part-of-name.17136/#post-105779

It will be very helpful for me if you solve the problem.

Thanks in advance.

Regards