Import Excel Spreadsheet Data into SQL Server Database Table

There are many ways to import/export excel data into sql server table.

Using SqlBulkCopy Common Method for sql server 2005/2008:

http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx

In SqlServer 2005 Using Integration Services

http://www.builderau.com.au/program/sqlserver/soa/How-to-import-an-Excel-file-into-SQL-Server-2005-using-Integration-Services/0,339028455,339285948,00.htm

Using Sql Server 2005 Import and Export Wizard

http://www.databasejournal.com/features/mssql/article.php/3580216/SQL-Server-2005-Import--Export-Wizard.htm

Using Sql Server 2008 Import and Export Wizard

http://dotnetslackers.com/articles/sql/Importing-MS-Excel-data-to-SQL-Server-2008.aspx