Last post Jun 15, 2012 02:20 AM by panric
Jun 12, 2012 03:09 AM|MM_MSDN|LINK
I need to export the data from Excel sheet to Sql server. what is the right procedure to attain this task?
Should I add Microsoft.Office.Interop.Excel dll or Microsoft Excel 12.0 Object Library? What is the RIGHT way and difference between these two?
Jun 12, 2012 03:11 AM|Mikesdotnetting|LINK
See this: How to import data from Excel to SQL Server
Jun 12, 2012 03:13 AM|Mudasir.Khan|LINK
eaisest way is to use MS Sql Server Import/Export Option
Jun 15, 2012 02:20 AM|panric|LINK
There is no easiest or best way to export data from Excel to SQL server, it really depands on the requirement you have. Technically, Excel is a database and sql server is also a databse of cource. So I would like to recommend Olebd for you here. Also,
I find a similar discussion to your question, please check my link: import Excel to database.