Import csv file data, into table using sql server

Posted by Mahendrabasutkar under Sql Server on 7/8/2011 | Points: 10 | Views : 98487 | Status : [Member] | Replies : 5
How to import csv file data, into table using sql server 2000.


Regard
mahendrabasutkar




Responses

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

Up
0
Down
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: Ksuresh on: 9/20/2012 [Member] Starter | Points: 25

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response