Hello all,

Just imagine that i have a Access database (C:\data.mdb) has a table more
than 65536 rows (table name: parts)

I want to import the parts table to excel. Can i do this without coding
(from 1 to 65536 to sheet1, the others to sheet2, sheet3 etc...)

If not, can i code it as: from record 1 to 65536 copy to sheet1, others to
sheet2, sheet3 etc.

Thanks in advance..

Regards,

Duck, have you looked into the PageSize property of the Database object? I
have not used it myself but read somewhere that this should allow you to
limit how many records are returned.
--
Charles Chickering

"A good example is twice the value of good advice."


"SupperDuck" wrote:

Hello all,

Just imagine that i have a Access database (C:\data.mdb) has a table more
than 65536 rows (table name: parts)

I want to import the parts table to excel. Can i do this without coding
(from 1 to 65536 to sheet1, the others to sheet2, sheet3 etc...)

If not, can i code it as: from record 1 to 65536 copy to sheet1, others to
sheet2, sheet3 etc.

Thanks in advance..

Regards,