Thanks Ron,

This helps considerably. Let me step it up a notch and see if this is
possible.

The Excel file I am populating looks similar to this:

Product XYZ 6/6/2005 6/13/2005
6/20/2005

Weekly Demand
Weekly Planned Production
Weekly Actual Production
Variance

What I am trying to do is populate the cells that for each week for each row
heading for the applicable product that is indicated. Is there a way to key
off of the product designation in the spreadsheet to select the appropriate
information in the database to populate the appropriate cells in the work
sheet?

"Ron Coderre" wrote:

That's not a lot of information to go on, but....in general, you could start
with:

1)Select the cell where the data pull will begin to store the Access data
2)DataImport External DataNew database Query
3)Select the MS Access data source
4)Select the table(s) you need to use and progress through the MS Query
screens.
5)At the end, you can either select to edit the query or just send the data
back to Excel.

6)Repeat for each sheet that is to receive the MS Access data.

Thereafter, you only need to select a cell in the data range and DataRefresh

Does that help?

--
Regards,
Ron