Agha
10-18-2011, 06:53 AM
Hi,
I wanted help with regards to writing a VBA code that would include an SQL query to pull data directly from SQL server on to my spreadsheet. However due to my limited knowledge of VBA I am having difficulty designing the connection string as well as the overall structure.
SQL Server = SNLDB2
Windows authenticated settings ( no login required)
Any help regarding this would be greatly appreciated. Please do let me know if any other piece of info. is required from my side. Thanks
I wanted help with regards to writing a VBA code that would include an SQL query to pull data directly from SQL server on to my spreadsheet. However due to my limited knowledge of VBA I am having difficulty designing the connection string as well as the overall structure.
SQL Server = SNLDB2
Windows authenticated settings ( no login required)
Any help regarding this would be greatly appreciated. Please do let me know if any other piece of info. is required from my side. Thanks