Import records from Access to Excel
Hi,
I would like to import 1 record from an Access Query into an Excel
worksheet, ideally placing each field from the Query to a specific location
on the Excel. This is for prepopulating forms in Excel from Access per record
(in the end, when there are 10 records in the Access Query I would need 10
Excel files with the same form filled in).
Off course this could almost be done using an Access report, but I need to
stick to a fixed Excel template
Thanks
|