Hi All
I need a sample code to connect, run a query in sql server and display
results in excel with these informations:
-worksheetname is "SHEET1"
-sql server name is "MYSQL"
-database name is "TEST"
-table name is "TABLE1"
-userid is "USER1"
-password is"PASS"
-my script file located in my computer D:\test\QUERY1.TXT(can be done in
query analyzer)
Best regards