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