Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
Do you mean that you have follow-on rows in a second sheet in the same
file? Pete On Jan 29, 8:30*pm, laredotornado wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
Hi Dave,
In Excel 2003 there are just 65536 rows (per sheet). What makes you think you have more? -- Kind regards, Niek Otten Microsoft MVP - Excel "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
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 at www.smokeylake.com/excel to 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 Kiosterud www.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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
We can assure you you don't have more than 65,536 rows in your Excel file.
Just hit Ctrl-End to find out. Regards, Fred "laredotornado" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to export to a CSV but my file has more than 65536 rows
On Jan 29, 6:20*pm, "Fred Smith" wrote:
We can assure you you don't have more than 65,536 rows in your Excel file. Just hit Ctrl-End to find out. Regards, Fred "laredotornado" wrote in message ... 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/exceltohandle 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 ----------------------------------------------------------------------"lare*dotornado" 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- Hide quoted text - - Show quoted text - I did as you said and it took me to row 65536 and column AM, which happened to be the last column in my spreadsheet. - Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Rows individuall to a new file? | Excel Discussion (Misc queries) | |||
How to put in over 65536 rows? | Excel Discussion (Misc queries) | |||
Add more than 65536 rows? | Excel Worksheet Functions | |||
Why does rngDataSource.Rows.Count = 65536 when worksheet Rows=95? | Excel Discussion (Misc queries) | |||
How can I open a large Excel file with more than 65536 rows? | Excel Discussion (Misc queries) |