To many rows for EXCEL to handle

M

moglione1

I have a file with over 70'000 rows in (MS EXCEL only holds aroun
65'000). Is there any way I can still perform a lookup on this file.

The file is saved as a CSV. Please dont tell me to open it in Wordpa
and do a search as I have been told this is not acceptable. (Pains).

PLEASE HELP M
 
D

Dave Peterson

Split it into smaller pieces and import each piece into its own worksheet...

Or don't use excel--maybe Access???
 
J

Jan Karel Pieterse

Hi Moglione1,
I have a file with over 70'000 rows in (MS EXCEL only holds around
65'000). Is there any way I can still perform a lookup on this file.

The file is saved as a CSV. Please dont tell me to open it in Wordpad
and do a search as I have been told this is not acceptable. (Pains).
Click to expand...

Yes, try Data, Get external data, New database query and follow
instructions from there.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
 
S

swatsp0p

The Excel limit is not flexible. You can either break your data into 2
or more sheets or use a Database.

Sorry.
 
Top