Thanks Gord. I do have Excel 2007 - I made the Company upgrade my laptop to
Excel 2007 specifically for the 1 million row feature. I got a little
stressed out Friday afternoon when I opened an existing file and could not
expand the file beyond the old 63k + limitation.

I have not yet found the "Office Button / Convert" feature - but I copied
the old worksheet into a new Excel 2007 file, and then expanded it - and it
works!

I am now officially divorcing Access and re-marrying my old spouse - EXCEL!

"JLatham" wrote:

See the above responses - especially the first one from Gord Dibben. The
'simple' answer is, as he said, get Excel 2007.

Barring that, the only practical way to do it is to use VBA code to open up
the Access database and start reading in records, one by one, and keeping a
counter of the records imported. When that gets to the limit for your
version of Excel (varies from 16K to 64K over the years) then you have the
code insert a new page and switch to that page to continue importing the
data: repeat as required until all records are read. Note: to get the same
number of rows in Excel 2003 that you can have in Excel 2007, you'll need a
total of 16 sheets.

But getting the new version of Excel may be the quick, easy answer. I just
finished giving some assistance to someone from another web site who had need
of the same thing: to be able to read in over 64K rows of data from either
.txt or .csv files and first thing I told him was to get Excel 2007. He did,
and this evening I coded up a process so that he can read the output from his
test equipment - sample file he sent to me had over 185,000 rows of entries.
Works like a champ - I even tested with one file that we created that
actually filled all 1,048,576 rows and it held up under the strain.

"Kevin" wrote:

How can I import Access data that exceeds 65 rows? I understand that Excel
can now handle 1 million rows - but I cannot figure out how.