laoding data from csv file

[AVL]

Hi,
I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

which is the best approach to load the daat wrt performance...

as of now, i'm planning to populate into a dataset and loop through the
dataset
record by record and update into the db..is there any other alternative?

 

[Herfried K. Wagner [MVP]]

I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

You could use SQL Server's 'BULK INSERT' T-SQL command directly:

BULK INSERT (Transact-SQL)
<URL:http://msdn2.microsoft.com/en-us/library/ms188365.aspx>

 

[MPF]

I've found this to be of great use

http://www.filehelpers.com/