Export to excel xlsx

[SjCc]

Regards,

I need VBA for a command button at report to export all data from table "todaydata" in access 2010 db to be exported in excel xlsx file at desktop with name "book1" the path of file is below

C:\Users\yousuf traders\Desktop

 

[bob fitz]

Perhaps you could use TransferSpreadsheet Method.

See: http://access-excel.tips/access-vba-cocmd-transferspreadsheet/

 

[AccessBlaster]

If you are exporting data based on a DATE you may want to write a parameter query, and then use it within the >> TransferSpreadsheet Method.