Output query to excel

  • Thread starter Thread starter Tamer Seoud
  • Start date Start date
T

Tamer Seoud

I created a user interface in Access that enables users to
view and print out reports. Some of the reports have to be
on Excel. Therefore, I want to output some queries to
Excel. What is the code for doing this from an event click?
Thanks for your help

Best Regards,
Tamer
 
Hi Tamer,

DoCmd.TransferSpreadsheet

I created a user interface in Access that enables users to
view and print out reports. Some of the reports have to be
on Excel. Therefore, I want to output some queries to
Excel. What is the code for doing this from an event click?
Thanks for your help

Best Regards,
Tamer
 
Back
Top