Insert Large Amounts of data into db

  • Thread starter Thread starter The Bear
  • Start date Start date
T

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.
 
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,
 
Back
Top