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

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