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

S

SupperDuck

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,
 
C

Charles Chickering

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split a text file with more than 65536 lines over many worksheets 5
Excel 2007 - ADO - More than 65536 rows - Problem ? 7
Insert rows in grouped sheets 2
Junp start my Select Case Macro 12
Reading in text file that is more than 65536 rows 2
Macro beginner help with making tables 1
Pivot Table Type Mismatch when More than 65536 rows 1
how do I import a CSV file with more than 65536 rows 9

Top