Getting Information from a query in ACCESS

[Debbie]

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?

 

[Guest]

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

 

[Debbie]

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.