How to import csv to database

Hi,

How to import csv file to sql server databse?Can anybody have the code?

Regards

Brijesh singh

You may use DTS (in SQL Server 2000) or SSIS (in SQL Server 2005).

How?
Checkout this link:http://www.sqldts.com/276.aspx

Good luck.

|||

you can find hereSpeed Up Copy Operations With SqlBulkCopy - Sql Server - CSV through sqlBulkCopy...[ADO.NET 2.0]

Good Luck./.