Importing from Access error
 

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?

Importing from Access error
 

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.
--
Kevin Backmann


"access hacker1" wrote:

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?

Importing from Access error
 

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.


"Kevin B" wrote:

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.
--
Kevin Backmann


"access hacker1" wrote:

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?

Importing from Access error
 

2007 has a limit of over 1 million rows.

"access hacker1" wrote:

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.


"Kevin B" wrote:

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.
--
Kevin Backmann


"access hacker1" wrote:

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?