To many rows for EXCEL to handle
 

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).

PLEASE HELP ME


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=466216

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

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

moglione1 wrote:

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).

PLEASE HELP ME

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=466216

--

Dave Peterson

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).

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

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

Sorry.


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466216