Best way to import spreadsheet into Sql Server?
Posted on 2010-08-23
I need users to upload a spreadsheet to my website (ASP.NET 4.0 framework), and then import the data from the spreadsheet into a SQL Server table.
I'll give them a template of the spreadsheet, so can control the spreadsheet's format.
What's the best approach to doing this? Should the spreadsheet be XLS, or CSV?
Also, most of the examples I've seen on the web rely on the old Microsoft.Jet.OLEDB.4.0, which I suspect I should avoid since it's deprecated. But is there another, better way? (I've seen Linq to Excel examples, but they all seem to rely on Excel being in XML format, and I was thinking native Excel would be more reliable and compact)