exporting data to excel sheet

[PWG]

I have an excel sheet that is set out like a form that is emailed to our head office for a purchase request.
I have built a data base in access to control our inventory at our end and it can produce a purchase request.
I have a report that access can print that looks like the excel sheet but it is not good enough form them and they want the excel sheet.
Is there a way to link Access to excel so that I can get the fields to populate on the excel sheet.
If anyone could point me in the right direction it would be great.

 

[arnelgp]

you can use docmd.TransferSpreadsheet method.
or you can open excel and add external connection to your access db.

 

[pbaldy]

You can use automation and have complete control. Here's some info:

https://www.devhut.net/2016/07/07/vba-automating-excel/