# Of Records In a Table

[Jess]

Hi,

I have to download a file then open it up in excel. Is
there a limit on the number of rows or records that will
open in Excel, in 1 table? If so how do I get around
this if there are more records?

Jess

 

[Dale Hymel]

65536 rows and 256 columns.
That is it....

Use Access

 

[Dave Peterson]

If you still need to use excel, you could use your favorite text editor and
split the downloaded file into smaller pieces.

And MS developed a macro that imports each line:

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+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm