CSV FILE TOO LONG FOR EXCEL

[lehigh46]

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]

How about opening the .csv file in Notepad and split it into smaller pieces.

Then you can open each of the smaller pieces separately.

 

[Sunil Jayakumar]

Hi,

Depending on what you are trying to do - my guess is probably some ETL work,
you could just import it into access, and run a query on it.

Access should be able to handle whatever you want to throw at it.

Warm regards

Sunil Jayakumar

Slightly off topic.

I really like UltraEdit as a text editor. It's not free, but inexpensive.

www.ayyoo.com/credit-cards.html