Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
r0dr1g0
 
Posts: n/a
Default csv load 64K workaround

Can anyone help me with the following problem?

I have a csv file that I'm trying to load into excel, it has about 80000
rows but I know the row limit of excel is 65536 has anyone been able to load
more than that?

Any help would be appreciated

Thanks

Rodrigo
  #2   Report Post  
N Harkawat
 
Posts: n/a
Default

open it in Word or wordpad
cust and paste 65K lines in one sheet
and the rest in other sheet


"r0dr1g0" wrote in message
...
Can anyone help me with the following problem?

I have a csv file that I'm trying to load into excel, it has about 80000
rows but I know the row limit of excel is 65536 has anyone been able to
load
more than that?

Any help would be appreciated

Thanks

Rodrigo



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
my files won't load completely in excel Emilee Excel Discussion (Misc queries) 1 February 3rd 05 01:57 AM
Need button or menu to load a file Spiff Excel Discussion (Misc queries) 4 January 20th 05 11:05 PM
System doesn't load Systray Dave Excel Discussion (Misc queries) 2 December 9th 04 04:10 AM
File will not load Jack Sheet Excel Discussion (Misc queries) 3 December 4th 04 02:41 PM
*.csv file wont load correctly Nightwing Excel Discussion (Misc queries) 3 December 1st 04 04:48 PM


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"