large data set insert

  • Thread starter Thread starter Mark A. Babcock
  • Start date Start date
M

Mark A. Babcock

I have an asp.net application where I am uploading a 8 - 25mb text file.
Then we are reading the lines from this text file to put into the database.
This could have between 40000-150000 lines in the text file depending on its
size. What is the best way to get this inserted into a datbase. Any
suggestions would help.
 
Hi Mark,

I think SQL DTS is a good choice in that case. It works fast with big amount
of data
 
You must log in or register to reply here.

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

import large text file 23
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
PPT 2003 Files Sizes 3
OleDbCommandBuilder insert query will not work? dataset to Access 4
Creating custom stamps in .pdf Adobe documents 1
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
CSV->Excel Data Problem 1
GNU NANO a useful basic text editor. 3

Back
Top