Export big access data-table to excel

[Malvina]

Hello world,

I am trying to output my query in access to excel by
simple clicking the button on the form. I wouldn't have
problems if my query would be less then 65536 rows. I
guess, I need to loop my rows in the query before 65536,
and if the record count reaches over that amount I need to
add another worksheet in excel. I got a little confused
on the code setting.
Any suggestions will be greatly appreciated.

Thank you,
Malvina S.

 

[Larry Wendel]

-----Original Message-----
Hello world,

I am trying to output my query in access to excel by
simple clicking the button on the form. I wouldn't have
problems if my query would be less then 65536 rows. I
guess, I need to loop my rows in the query before 65536,
and if the record count reaches over that amount I need to
add another worksheet in excel. I got a little confused
on the code setting.
Any suggestions will be greatly appreciated.

Thank you,
Malvina S.

.
Try creating mutiple queries. then combine the excel

worksheets into one.