CSV splitter (divide large CSV files)

[patgio]

The CSV splitter is pretty good. However, I have a CSV file with 750,000 lines. The CSV splitter stops at 350,000.

Any way to make it go to 750,000?

Alternatively is there a way to make the CSV splitter delete rows that have been split to a file?

thanks for you help -- and Scorpion.. great great program.

[scorpion]

patgio, could it be damaged file? I've splited a csv file with more than a million rows without any problem.

[FirstFerret]

I knew a little VB app would be simple but wanted to hunt around as re-inventing the wheel is not my style.

How many intern hours have been wasted splitting files I cannot begin to tell you!

Today, nay, for all future database loading time, you are my hero.

[alexs]

Scorpion this is a great tool for me.
Me and about 30 people would like to thank you for this application.
It's going to make our lives so much easier.

[bossxero]

Originally Posted by alexs

Scorpion this is a great tool for me.
Me and about 30 people would like to thank you for this application.
It's going to make our lives so much easier.

Then, just press the Thanks button

[aldrincantos]

thank you very much for this very useful tool. Now, I won't have to create my own.

[nandenverma@yahoo.com]

hi this is my first message

[jooon3]

Hi,

I found this would be very helpful but when I executed it, it was stopped due to the out-of-memory exception.

My csv file is slightly over 2GB and is supposed to have about 50*50000 rows. But it stopped after making 31st file. (I just let the default setting as it is.)

I have Core 2 Duo 2.5Ghz with 3.5GB memory which is pretty new.

Thank you,

Joon

[scorpion]

Your CSV file might be corrupted, or each line is very long. You should try to reduce the number of lines per file. First, reduce it to 20000. If it doesn't work, reduce to 10000... 5000... 2500 until the error goes away.

Somehow, I think there's something wrong with your RAM or system memory settings. I used to split files larger than 2GB fine. If you're running Vista, you might want to test the memory.