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