On Jan 29, 2:38*pm, "Earl Kiosterud" wrote:
Dave,

First of all, the problem isn't a save problem -- the problem is that Excel 2003 and prior
only hold 65K rows per sheet. *Using Excel 2007, with its million rows per sheet, is one
solution. *Presumably your data came from some file -- you don't say anything about it.
Another would be to write a macro that reads your input file, whatever that is, and filled a
sheet, then next sheet, then the next, etc. *But then you'd need a macro to write the CSV,
since Save As only saves one sheet. *You can use the code in the Text Write Program atwww.smokeylake.com/excelto handle the CSV formatting issues -- you'd just have to modify it
to write consecutive sheets to one file.

Say more about the input file.

--
Regards from Virginia Beach,

Earl Kiosterudwww.smokeylake.com

----------------------------------------------------------------------"laredotornado" wrote in message

...



Hi,

I'm using MS Excel 2003 on Win XP. *I have a very large file and when
I open it I only see 65,536 rows. *I want to save it to CSV (text) but
I'm afraid if I do "Save As..." I'll only be saving out the first
65,536 rows.

Is there a way to export to CSV and keep all rows?

Thanks, - Dave- Hide quoted text -

- Show quoted text -

Thanks all for your responses. The file was auto-generated by a Java
program that read rows from a database and then created a row in the
Excel file for each of them. While I'm not sure yet if there are more
than 65536 rows, the file is 40MB, so I'm guessing there are. Hope
that clarifies things.

Earl, your suggestion about upgrading to Excel 2007 is a good one, but
I may not be able to do that in the short term.

Thanks again, - Dave