write an access code to extract data

[Saeed]

using Access 0365
How would i be able to write a program to be able to do a query on a table and write that up into an excel sheet.

I cant install anything on the machine .


Would I be able to use VBS to do this ?

Thanks

[xps35]

This can be done with just one line of code using DoCmd.TransferSpreadsheet.

[Welshgasman]

Just use TransferSpreadSheet?
https://docs.microsoft.com/en-us/off...ferspreadsheet

[Saeed]

Just use TransferSpreadSheet?
https://docs.microsoft.com/en-us/off...ferspreadsheet

Thanks I ll give that a try.