OK, so the need to export Excel Spreadsheet data over to a SQL Server Database Table does not present itself to me everyday. No matter, this is just one more talent that I can not put under my belt thanks to the article below.
Per another question I received, the last thing I wanted to mention on the subject of Excel is that you can use SqlBulkCopy to transfer Excel Spreadsheet data at high speeds to a SQL Server Database Table. I talked about SqlBulkCopy in a previous ADO.NET Tutorial:
* SqlBulkCopy – Copy Table Data Between SQL Servers at High Speeds – ADO.NET 2.0 New Feature
You can view my other posts on Excel for more information about using ADO.NET to read and write to Excel Workbooks and Worksheets:
* Reading Excel Worksheet and Column Schema Information Using ADO.NET 2.0 and GetSchema
* Reading and Writing Excel Spreadsheets / Worksheets Using ADO.NET C# DbProviderFactory….. Source: davidhayden.com
[tags]database,data,excel,sql server,spreadsheet[/tags]