how to import and export data from excel to sql server and sql server to excel

Question

User-742704163 posted

i want to import my sql table into excel and excelsheet to sql server.

i have excel sheet and i want to export it into sql server and another file witch is in sql server import it into excel.

Answer 1

User1508394307 posted

I prefer to use http://npoi.codeplex.com (for more information, see example package from http://npoi.codeplex.com/releases)

Answer 2

User1867929564 posted

i) Use SSIS Packages
ii)Openrowset
http://msdn.microsoft.com/en-us/library/ms190312.aspx

Answer 3

User-1694870838 posted

Hi,

You can import Excel data into SQL Server Database table using SqlBulkCopy,please refer to this link:http://www.davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx 

If you export data from SQL Server to excel please refer to http://www.mssqltips.com/tip.asp?tip=1202 

Best Regards,

Damon