Export big access data-table to excel

  • Thread starter Thread starter Malvina
  • Start date Start date
M

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.
 
-----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
Click to expand...
worksheets into one.
 
Back
Top