creating a table to export to excel

[businessman]

how easy is it to have access create a table and export it to excel, and then have fields on an already made spreadsheet filled in.

 

[Pat Hartman]

1. You don't need to create a table, you can export a query.
2. The TransferSpreadsheet Method/Action will export a query/table to a specific sheet in a workbook. If you want to place fields here and there, you will need to do it with VBA automation. Search the MSDN library for Excel automation examples. You can also find some in Excel Help. Access will only display help for automating Access. You need to find help for automating a product in that product's help file.