relative path to excel file for query

nale

New member
Joined
Feb 16, 2017
Messages
1
Reaction score
0
Points
0
Hi, all
is it possible to use relative path (current path) in a excel file with a SQL query to itself?
I can create such a query, but then if the file is renamed, moved or shared with other people, the query stops working because the original full path and filename are hardcoded in the connection string and SQL statement.
I know there is a way to do that with Power Query, but I would like to do it with MS Query.
thanks a lot
 
Back
Top