CSV FILE TOO LONG FOR EXCEL
 

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

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

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

Slightly off topic.

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



Tom Ogilvy wrote:

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

--

Dave Peterson

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" wrote in message
...
Slightly off topic.

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



Tom Ogilvy wrote:

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

--

Dave Peterson

www.ayyoo.com/credit-cards.html