CSV FILE TOO LONG FOR EXCEL

L

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
 
D

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.
 
D

Dave Peterson

Slightly off topic.

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

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

Dave Peterson said:
Slightly off topic.

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

www.ayyoo.com/credit-cards.html
 
Top