Passing variable values (complete specifically path of an MDB) inside a SQL query in

Hi Folks,

There's this application we are working on here, written completely in excel and uses Pivot tables. Now, we have a particular pivot table here that gets the data from a SQL query (using Microsoft Query I think).

Here's what I do to get to the query:
Right click on a cell in the Pivot sheet and Go to the Pivit Table Wizard. Subsequently, follow all the steps till I get to the SQL query.

Here's the query I get

Please Login or Register  to view this content.

Now, the highlighted RED section is a path to an MDB file placed within the same folder. We need to remove all hardcoding references to this path so that in case the entire folder gets moved to some other place (say F:\topstat\xls-ro\....), it does not break.

The MDB file and the Pivot sheet will ALWAYS remain in the same folder structure.

Any help or inputs on this would be appreciated.

Thanks