How to export access query to excel (1 Viewer)

rchumpitaz

New member
Local time
Today, 14:13
Joined
Sep 7, 2018
Messages
7
Hi everyone,
I'm trying to do this action and after several investigation I found that DoCmd.TransferSpreadsheet do the job, but just one time because when I'm trying to export the data again the data doesn't overwrite in the file and I have to eliminate the archive to generate a new one. Anyway I want to know if there's a way to open the excel file after exporting it.

Thanks
 

Users who are viewing this thread

Top Bottom