Question: how to export access data to excel in vba?
Answer: Create VBA Procedure. Microsoft Access provides the very handy method DoCmd. TransferSpreadsheet to export, import, or link Excel data. ... 
Run Procedure. Run the procedure and check that the file was created in the path listed in the excel_file_name variable in your procedure.