Answered by:
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.
Tuesday, May 31, 2011 3:04 PM
Answers
-
User1508394307 posted
I prefer to use http://npoi.codeplex.com (for more information, see example package from http://npoi.codeplex.com/releases)
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, May 31, 2011 3:09 PM -
User1867929564 posted
i) Use SSIS Packages
ii)Openrowset
http://msdn.microsoft.com/en-us/library/ms190312.aspx- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, June 2, 2011 6:03 AM -
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, June 7, 2011 3:12 AM
All replies
-
User1508394307 posted
I prefer to use http://npoi.codeplex.com (for more information, see example package from http://npoi.codeplex.com/releases)
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, May 31, 2011 3:09 PM -
User1867929564 posted
i) Use SSIS Packages
ii)Openrowset
http://msdn.microsoft.com/en-us/library/ms190312.aspx- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Thursday, June 2, 2011 6:03 AM -
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
- Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
Tuesday, June 7, 2011 3:12 AM