How to find out database location in MS Query?

[surotkin]

Hello everyone,

I have an MS EXCEL spreadsheet which retrieves data from MS ACCESS database using Microsoft Query.
This spreadsheet was developed by another person. I need to support this spreadsheet.

Does anybody know how to find out the database name and location the data are retrieved from?

Your help is appreciated.

surotkin

[Ron Coderre]

Try the free Pivot Play add-in at Debra Dalgleish's website:
http://www.contextures.com/xlPivotPlayPLUS01.html

It displays details of the data source and the query.

Does that help?

[surotkin]

Hi Ron,
thank you very much!

It works perfectly!

surotkin