Timeline for Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database?
Current License: CC BY-SA 3.0
2 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
May 1, 2013 at 13:18 | comment | added | datagod | Creating a linked server (or even an adhoc open query) works great, but be careful of headers, titles, merged cells, etc. as the data type of an entire column seems to be determined by the first row. | |
May 1, 2013 at 13:07 | history | answered | user23243 | CC BY-SA 3.0 |