View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] d7666@hotmail.com is offline
external usenet poster
 
Posts: 5
Default Importing CSV file with more than 65535 rows to Excel 2007

Currently I am running Excel 2002. I am aware of the 65535 row limit
in this version.

Excel 2007 is stated in
http://office.microsoft.com/en-us/ex...778231033.aspx
to have 1,048,576 rows.

My question is, if my raw data is a single CSV file of more than 65535
rows, can this be *directly* imported into Excel 2007 by <File <Open
<filename.csv etc.?

Reason for question is I have seen questions concerning difficulty
with more rows than 65535 but most seem to be about xls files [old
versions] solved with xlsx [2007] files ... but is there a restriction
on CSV files *before* saving as xlsx ?

I don't have access to Excel 2007 to try this out ... but if it does
work I might buy it.


--
Nick