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

Import records from Access to Excel
 

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