273K lines may be to much for notepad. Maybe wordpad or word

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
How about opening the .csv file in Notepad and split it into smaller
pieces.

Then you can open each of the smaller pieces separately.

lehigh46 wrote:

Hi All,

I'm trying to load a .csv file, but it won't fully load because it's
longer than 65,536 lines.

How can I load the entire file, even if it goes to a second worksheet.

The file is 3 columns wide.

Thanks for your help

Tom Snyder

--

Dave Peterson