Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
I'M TRYING TO IMPORT DATA FROM A .ASC FILE. IT CONTAINS 77,267 LINES. I DID A
FIRST IMPORT THAT ALLOWED ME TO IMPORT UP TO LINE 65,536. NOW, WHEN I TRY IMPORTING THE REST (FROM 65,537 TO 77,267) & I NIPUT THE LINE NUMBER, IN THE WIZARD, TO START AT ROW 65,537, IT TELLS ME THAT THE INTEGER IS INVALID. I AM TRYING TO DO THIS ON A SECOND BLANK WORKSHEET, AS INSTRUCTED. I'VE EVEN TRIED TO START THE SECOND IMPORT AT LINE 50,000, FIGURING IT'LL IMPORT TO LINE 77,267, BUT INSTEAD STILL ONLY GOES UP TO LINE 65,536 AS IN THE ORIGINAL IMPORT. HOW DO I GET THE LAST 11,000-ODD LINES INTO EXCEL? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
Microsoft has a macro solution that may help:
http://support.microsoft.com/default...;EN-US;q120596 XL: Importing Text Files Larger Than 16384 Rows (written for xl95, but has a note to change stuff for xl97+) I'd just use my favorite text editor and split the data into smaller pieces--and then import each piece to a new worksheet. PAULP wrote: I'M TRYING TO IMPORT DATA FROM A .ASC FILE. IT CONTAINS 77,267 LINES. I DID A FIRST IMPORT THAT ALLOWED ME TO IMPORT UP TO LINE 65,536. NOW, WHEN I TRY IMPORTING THE REST (FROM 65,537 TO 77,267) & I NIPUT THE LINE NUMBER, IN THE WIZARD, TO START AT ROW 65,537, IT TELLS ME THAT THE INTEGER IS INVALID. I AM TRYING TO DO THIS ON A SECOND BLANK WORKSHEET, AS INSTRUCTED. I'VE EVEN TRIED TO START THE SECOND IMPORT AT LINE 50,000, FIGURING IT'LL IMPORT TO LINE 77,267, BUT INSTEAD STILL ONLY GOES UP TO LINE 65,536 AS IN THE ORIGINAL IMPORT. HOW DO I GET THE LAST 11,000-ODD LINES INTO EXCEL? -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
"PAULP" wrote: I'M TRYING TO IMPORT DATA FROM A .ASC FILE. IT CONTAINS 77,267 LINES. I DID A FIRST IMPORT THAT ALLOWED ME TO IMPORT UP TO LINE 65,536. NOW, WHEN I TRY IMPORTING THE REST (FROM 65,537 TO 77,267) & I NIPUT THE LINE NUMBER, IN THE WIZARD, TO START AT ROW 65,537, IT TELLS ME THAT THE INTEGER IS INVALID. I AM TRYING TO DO THIS ON A SECOND BLANK WORKSHEET, AS INSTRUCTED. I'VE EVEN TRIED TO START THE SECOND IMPORT AT LINE 50,000, FIGURING IT'LL IMPORT TO LINE 77,267, BUT INSTEAD STILL ONLY GOES UP TO LINE 65,536 AS IN THE ORIGINAL IMPORT. HOW DO I GET THE LAST 11,000-ODD LINES INTO EXCEL? A tricky one, I've not been able to do this myself. iIstead, i reduced the amount of lines from the source to make sure it came in under the max limit in XL. Even then, it was hugely unwieldy. Can you import it into say access first and do something to it so that you don't need all those rows? Otherwise you might have to start your rows at the first row in the second spreadsheet. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I NEED TO IMPORT MORE THAN THE 65,536 LINES EXCEL ALLOWS
Basically, there is a limit of 32k for the number of lines that you can
skip over for the second import - this means that your second sheet will contain rows from 32k up to 77,267, so you will have to remove the duplicates from either the first or the second sheet after you have imported the file. As I have Quattro Pro 9, with 1 million row capability, I generally use this for very large files, then copy and paste sections of less than 64k into separate Excel sheets - I understand that the next version of Excel will have the same larger capacity. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I import data (distance and time) from MapPoint to Excel? | Excel Discussion (Misc queries) | |||
?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
On an import to excel a two digit date still is not right after c. | Excel Discussion (Misc queries) | |||
How do I change a data series from bars to lines in an Excel char. | Charts and Charting in Excel | |||
How do I import a WORD file into EXCEL? | Excel Discussion (Misc queries) |