Does anyone know how to change an ODBC connection without having to recreate a SQL query? I have done this successfully with access, but not excel.
Does anyone know how to change an ODBC connection without having to recreate a SQL query? I have done this successfully with access, but not excel.
If you mean you want the exact same query to just point at another database then you could always copy the SQL statement from within MSQuery (hit the SQL button) and then create a new query, point it at the new db and paste the SQL into it. If you are creating the query in code, then it should be a straightforward matter of simply changing the connection string.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks