Read *.csv which contains more than 65565(?) records

0

0-0 Wai Wai ^-^

Read *.csv which contains more than 65565(?) records

Hi.
I forget the number, but it seems Excel can manage to deal with 65565(?) records
only.
It can't display more than that, right?

I have a *.csv with more than 100,000 records.
So what can I do?
Any help!
 
M

mjones

Hi,

It's been a long time, but as I recall, the last time I did this, I
converted the file to a txt, then I brought it into Access. Then, I
sorted it and output it into two separate Excel files.

I know this isn't much detail, but hopefully it gets you in the correct
direction. The trickiest part was running the Access query to divide
the data. And I can't remember how I converted it to txt, but I
remember it was simple.

Good luck, hope this helps,

Michele
 
0

0-0 Wai Wai ^-^

It seems to be quite complicated and time-consuming.
Do you think if there're any third-party application or plug-in which can do
this for me?
Or if there's any program which can read more than 65565 records?
 
P

Pete_UK

It's actually 65536 records (unless you want to wait for Excel 12).

Quattro Pro (and I think Lotus123) has up to 1,000,000 row capability -
I have QP v9 from 1999, and I use this for very large files like the
one you describe. I usually split it into Excel-sized sheets from
there.

If you had less than 96,000 records you could read it into Excel in two
passes, as you have the ability in the Data Import Wizard to skip over
up to 32k records.

Have you tried to put the data into WordPad and then split it into 2
files?

Hope these comments help.

Pete
 
Top