Import csv file data, into table using sql server

Posted by Mahendrabasutkar under Sql Server on 7/8/2011 | Points: 10 | Views : 100680 | Status : [Member] | Replies : 5

How to import csv file data, into table using sql server 2000.

Regard
mahendrabasutkar

Reply | Reply with Attachment

Posted by: PandianS on: 7/8/2011 [Member] [MVP] Silver | Points: 25

0	Hi 1. You can use Import in SQL Server (Right Click on Database --> Tasks --> Import Data...) 2. Source will be Excel file 3. Destination will be SQL Server Cheers www.sqlserverbuddy.blogspot.com Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Susanthampy on: 7/9/2011 [Member] [MVP] Bronze | Points: 25

0	Hi, Refer this link, http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/ http://www.teratrax.com/tdm/help/import_sql_server.html http://stackoverflow.com/questions/6464601/validate-csv-file-data-before-import-into-sql-server-table-in-ssis Regards, Susan Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Regards,
Susan

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ksuresh on: 9/20/2012 [Member] Starter | Points: 25

0	Hi All, I able done in local machine but i want my excel sheet file import in to Sql Server Database which on Godaddy.com Becoz My website hosted on Godaddy.com How to do this Please any one can help me.... Thanks in Advance. Suresh Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Eva2012 on: 9/20/2012 [Member] Starter | Points: 25

0	This .NET Excel component can export your csv file to datatable. http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Megan00 on: 9/24/2012 [Member] Starter | Points: 25

0	I think below article can help you much: http://everlasting129.weebly.com/8/post/2012/09/csv-to-datatable-import-csv-to-datatable-with-c-vbnet.html Never give up! Smile to the world! http://excelcsharp.blog.com/ Mahendrabasutkar, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts