Splitting data on sheets for more than 65536 rows...
 

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,

Splitting data on sheets for more than 65536 rows...
 

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,