Inserting cell values into sql server RSS

• • Reply
  

  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

• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: Inserting cell values into sql server

  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

  • Edited by decker dong - msft on Jan 21, 2013 12:33 AM
  • Marked as answer by decker dong - msft on Jan 25, 2013 01:14 AM