Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 21, 2013 12:33 AM by Decker Dong - MSFT
Member
650 Points
674 Posts
Jan 19, 2013 04:38 PM|LINK
Dear all,
How can i insert data which is entered in excel sheet cells in to ms sql server table?
Thanks
Nick
All-Star
118619 Points
18779 Posts
Jan 21, 2013 12:33 AM|LINK
nicklibee How can i insert data which is entered in excel sheet cells in to ms sql server table?
Two ways:
1) Use the Wizard window by importing data contents from Excel to SQL in the SQL Management Studio.
http://www.66pacific.com/sql_server_import_from_excel.aspx
2) Also you can try this by referring BulkCopy from Excel into Access:
http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net
nicklibee
Member
650 Points
674 Posts
Inserting cell values into sql server
Jan 19, 2013 04:38 PM|LINK
Dear all,
How can i insert data which is entered in excel sheet cells in to ms sql server table?
Thanks
Nick
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Inserting cell values into sql server
Jan 21, 2013 12:33 AM|LINK
Two ways:
1) Use the Wizard window by importing data contents from Excel to SQL in the SQL Management Studio.
http://www.66pacific.com/sql_server_import_from_excel.aspx
2) Also you can try this by referring BulkCopy from Excel into Access:
http://www.codeproject.com/Articles/16922/SQL-Bulk-Copy-with-C-Net