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
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