Mark,

You can use ADO or DAO to navigate through your Access database. The
copyasrecordset method is extremely useful in copying over data once the
connection has been established.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Mark" wrote:

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