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...