Splitting large Excel csv file

[Rick]

Hi...

I was sent a large excel file (about 50 mb) with a .csv extentsion
which I am having problems loading into Excel.
Whenever I try to load the file - I get a message saying "file not
loaded completely" - The file then loads - but I assume with data
missing which of course I would have no way of knowing what data, and
how much of it is missing.
Can anyone advise the easiest way (I'm am a non-techie)to get around
this size limitation. I know there are file splitters but after they
are split, you have to reintegrate them back to the original file to
use it.
Is there any way to split the file into separate standalone files so
I could load each one into a single excel worksheet?
What is the maximum size of a file which can be loaded into Excel.
I'm not familiar with the .csv extension for Excel files so I'm not
sure if that is part of the problem also.
Any help on what I can do (the simplest way possible) would be
greatly appreciated..
Thanks so much in advance..
Rick

 

[Dave Peterson]

I'd use my favorite text editor to split it up into many pieces (and import each
piece separately).

Or you could use a macro that imports each line:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm