Populate Excel Template with Data from Access

[Chris Moore]

Office 2002:

I am seeking a way to populate an Excel template with data from an Access
query. My thought process is that an Excel template could maintain a
consistent look and feel for the spreadsheet and also do some calculations on
the live data which would be provided by Access.

The problem seems to be that this would require "mapping" the results of the
Access query to specific cells in Excel. While I understand anything is
possible via VBA wizardry I'm wondering if there is a more user friendly way
to accomplish this. Thanks!

-Chris

 

[Ken Snell \(MVP\)]

If the cells that are to receive the data are not contiguous, then you
indeed will have to map the query to the cells by using a Recordset of the
data and then writing each field of each record into the correct cells.

 

[Klatuu]

Another possibility would be to use MSQuery in Excel and pull the data from
Access. You could then construct an Excel Macro that would pull the data
and put it where every you want it.

If it is contigious, but not starting in A1, you might consider the
CopyFromRecordset method.