automate text import

  • Thread starter Thread starter Jonathan Randle
  • Start date Start date
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
 
Hi Kathy,

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

Thanks for your help :)
 
Back
Top