MVP David Hayden has written some good articles regarding the data import/export between Excel and SQL Server. They can be found in links below:
Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy
Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory
Thanks David.
No comments:
Post a Comment