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