loading data from csv file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AVL - 12 Feb 2008 11:56 GMT

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?

Reply to this Message

Mark Rae [MVP] - 12 Feb 2008 12:01 GMT

> I've a requirement to load the data froma csv file to sql server table
> programaticlly..
[quoted text clipped - 4 lines]
> dataset
> record by record and update into the db..is there any other alternative?

You asked this question on 8th February - it has already been answered...

Signature

Mark Rae
ASP.NET MVP
http://www.markrae.net

Reply to this Message

AVL - 13 Feb 2008 09:44 GMT

But the solution specified is wrt to .Net 2.0..i'm working on .net 1.1.
Thats why I've posted againg

> > I've a requirement to load the data froma csv file to sql server table
> > programaticlly..
[quoted text clipped - 6 lines]
>
> You asked this question on 8th February - it has already been answered...

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...