The problems arise when Excel 2007 is running in compatibility mode - this
happens when you open an XLS file in Excel2007
I have just made a CSV with 12,000 rows. It opened just fine in XL2007 will
all rows present and accounted for
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
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