Home:ALL Converter>How do I import an Excel spreadsheet into SQL Server 2008R2 database?

How do I import an Excel spreadsheet into SQL Server 2008R2 database?

Ask Time:2014-02-12T23:23:54         Author:Sudeep Devkota

Json Formatter

I have got huge list of contact information in an Excel sheet that I would like to turn into table in the database so that I can maintain them in the database.

I tried following the import/export flat file import from the SQL Server 2008 R2, but it did not work. Can anyone tell me how do I successfully import the spreadsheet into a table in the database?

Thanks

Author:Sudeep Devkota,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/21732069/how-do-i-import-an-excel-spreadsheet-into-sql-server-2008r2-database
yy