how to read .sql file using excel macro and execute?

[nani]

I wrote VBA code in such a way , connect sql DB and run query which is hard-coded and print data in excel.
now i want macro to read .sql file , execute and print data in excel
can any one please help me on this..

 

[Hui]

I'd also love this solution....

 

[nani]

can any one pls reply to thread

 

[Hui]

Have you asked this question in an SQL forum ?

 

[NARAYANK991]

Hi ,

Have you seen this link :

http://www.vb-helper.com/howto_sql_script.html

Narayan

 

[Deepak]

Cross Posted!!

http://stackoverflow.com/questions/30892927/how-to-read-sql-file-using-excel-macro-and-execute