Thanks for all the reply, i been focus on other things and just read your messages. So it seems it is already optimized (Casting). Yes, on the latter part they...

Thanks for the reply,

The file is tab delimited, and import the first 950,000+ records, then an error occured. I cannot open the file in TextPad, EditPlus text viewer, that's why...

Hi,

I know my reply is just too late for this thread but i have almost the same problem. i importing a 15mil rows (around 3.4gb) and after 1M rows it...