Importing from Access error

[access hacker1]

I have a table in Access which has 89,999 records which are all autonumbered
in sequential order. when I import this table into Excel the records get out
of sequence. Is there a limitation in how many records I can accurately
import into Excel from Access?

 

[Kevin B]

If you're using Excell 2003 or less your row limit is 65536 per worksheet.

You could split the data up between worksheets but you could not get all the
records in to a single sheet.

 

[access hacker1]

Im using excel and access 2007. Do you know what the limit is per worksheet
for Excel 2007 or where I could go to find out. I can't even find a number
for microsoft. Thank you.

 

[Duke Carey]

2007 has a limit of over 1 million rows.

Im using excel and access 2007. Do you know what the limit is per worksheet
for Excel 2007 or where I could go to find out. I can't even find a number
for microsoft. Thank you.