Insert Large Amounts of data into db

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.
 
I

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about comparing large lists 2
insert data into table 1
Working with Complex DataSet - Creating and Pass thru Transformati 2
C# File + DB Transaction 2
C3 Newbie DataAdapter question 8
Compare disparate data using C# 1
Architecture question on parsing a large text file 21
Import large CSV file data into Oracle Table 3

Top