RE: Importing Data from Access into Excel

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 spread*** to select the appropriate
information in the database to populate the appropriate cells in the work
***?

"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)Data>Import External Data>New 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 *** that is to receive the MS Access data.
>
> Thereafter, you only need to select a cell in the data range and Data>Refresh
>
> Does that help?
>
> --
> Regards,
> Ron
>
.