I would like to pull information into an excel sheet, possibly with a
lookup function, from a query (Age Report) in ACCESS. Is there a way
to do this?

Data--Get external data--New database query

Navigate to your Access db, select the query, click OK and you'll see the
data appear in your spreadsheet.

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Debbie" wrote:

I would like to pull information into an excel sheet, possibly with a
lookup function, from a query (Age Report) in ACCESS. Is there a way
to do this?

On Feb 23, 9:20 am, Dave F wrote:
Data--Get external data--New database query

Navigate to your Access db, select the query, click OK and you'll see the
data appear in your spreadsheet.

Thank you so much. This works great! It even refreshes the data.

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.



"Debbie" wrote:
I would like to pull information into an excel sheet, possibly with a
lookup function, from a query (Age Report) in ACCESS. Is there a way
to do this?- Hide quoted text -

- Show quoted text -