Home > Asp.net, Sql Server > Import Excel Spreadsheet Data into SQL Server Database Table

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

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: