imported records

[ritz]

Can anyone tell me if there is a way that you can change
the # of records that import to excel. I believe it is
63000 something.

Thanks

 

[Jason Morin]

Your limit is 65,536 records per worksheet. You cannot
extend that limit. The number of worksheets, however, is
limited only by memory.

HTH
Jason
Atlanta, GA

 

[Dave Peterson]

Maybe you could use your favorite text editor and split your data into
pieces--and then import each piece to a new worksheet.

Microsoft has a macro solution that does something similar:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)