ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   csv load 64K workaround (https://www.excelbanter.com/excel-worksheet-functions/16501-csv-load-64k-workaround.html)

r0dr1g0

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

N Harkawat

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





All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com