Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
I have occasion to extract data from ACCESS files containing more than 65000
rows, so I use MSQuery and filter the data to one sheet, and then run another to filter more to another sheet, etc, eventually getting all the rows......clumbsy but it works......maybe it would work with CSV files too....don't know Vaya con Dios, Chuck, CABGx3 " wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
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 | | |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
On May 12, 8:03*pm, "Bernard Liengme" wrote:
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 MVPhttp://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- Hide quoted text - - Show quoted text - Thanks for quick reply. -- Nick |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
On May 12, 8:18*pm, "Homey" <none wrote:
Text file with 1,048,576 rows opens ok for me in Excel 2007. slow though. Thanks for quick reply. -- Nick |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
On May 12, 8:38*pm, wrote:
In the mean time for an urgent work around I found in MS Knowledge Base http://support.microsoft.com/default...b;en-us;120596 that contains a macro for importing large row text files by splitting the input into multiple worksheets. I have it tested and have it running, and it does the urgent CSV file job I needed, and although sucessful it does terminate with a debug error. While I've created macros before, the script in this one is beyond my current skills, so for now I've added a reply to the MS page with a feedback comment. -- Nick |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing CSV file with more than 65535 rows to Excel 2007
On May 13, 10:38*am, wrote:
On May 12, 8:38*pm, wrote: In the mean time for an urgent work around I found in MS Knowledge Base http://support.microsoft.com/default...b;en-us;120596 that contains a macro for importing large row text files by splitting the input into multiple worksheets. *I have it tested and have it running, and it does the urgent CSV file job I needed, and although sucessful it does terminate with a debug error. While I've created macros before, the script in this one is beyond my current skills, so for now I've added a reply to the MS page with a feedback comment. -- Nick A further test, I've found the debug error only arises if the input files is *exactly* 65536 or exact multiples of 65536 lines long. Works fine with other file lengths. -- Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Swap . and , when importing to Excel 2007 | Excel Discussion (Misc queries) | |||
=850*77.1 = 65535 | Excel Discussion (Misc queries) | |||
Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
Importing a text file into Excel with too many rows? | Excel Discussion (Misc queries) | |||
Line chart with more than 65535 data values | Charts and Charting in Excel |