I read some documentation on the web today about exporting data from SQL Server to Excel, and doing the reverse, exporting data from Excel to SQL Server.
Actually, this link was pretty good:
For one thing, what is Excel linked server "EXCELLINK"?
This is pretty good too:
This is very good; gets pretty complicated though:
I’m still pretty confused about how it all works. It’s very easy to turn on the Macro Recorder in Excel, connect to SQL Server, choose a Table, and import date from that Table, but I would like to know if there is a more eloquent way of retrieving data, rather than doing something like:
"ODBC;DRIVER=SQL Server;SERVER=EXCEL-4J2W8KYNP\SQLEXPRESS;UID=;APP=2007 Microsoft Office system;WSID=EXCEL-4J2W8KYNP;Trusted_Connecti" _
View Complete Post