Insert Large Amounts of data into db

[The Bear]

I'm looking for a way to insert a large amount of data into a db table.
I'm reading the data from a file. It's about 250,000 records.One per line

thanks

T.B.

[Peter Jausovec]

Hi,

Take a look at this thread:
http://www.dotnet247.com/247referenc...49/245003.aspx

--
Regards,
Peter Jausovec
(http://blog.jausovec.net)
"The Bear" <bu**********@hotmail.com> je napisal v sporoèilo
news:F_********************@rogers.com ...

I'm looking for a way to insert a large amount of data into a db table.
I'm reading the data from a file. It's about 250,000 records.One per line

thanks

T.B.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Use BULK INSERT or DTS

of course if you are going to do this once maybe it's easier if you just
read each line and use a sql query as usual, you can let it run one night
and it will be done by the next day
cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
"The Bear" <bu**********@hotmail.com> wrote in message
news:F_********************@rogers.com...

I'm looking for a way to insert a large amount of data into a db table.
I'm reading the data from a file. It's about 250,000 records.One per line

thanks

T.B.