Text file with 1,048,576 rows opens ok for me in Excel 2007. slow though.


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