automate text import

J

Jonathan Randle

Hi,
I'm trying to automate the insertion of a large csv file (~2 million rows).
Reading the file line by line and doing a single insert is too slow (i can
only get about 600 rows per second this way). Is there a bulk insert
interface, or some other method of achieving the same result but with better
performance?

Thanks for any help,
Jonathan
 
J

Jonathan Randle

Hi Kathy,

I looked into Transfertext, and it seems to be exactly what i'm after.

Thanks for your help :)
 

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

Can not import .csv file 1
Import Multiple CSVs with a twist 4
Import errors importing Text into existing table, header vs no hea 3
Fastest way to sort 14
import contacts 1
concatenating Line Input 3
Processing large files with TextFieldParser 3
unable to import from csv to memo field 1

Top