Can the database name be easily changed from all ODBC queries in

Markku_E 

there are several ways to change the database name for all your ODBC queries in Excel without manually editing each one. Here are three options:

1. Modify connection strings:

• This method involves editing the connection strings directly within your ODBC queries. Each query likely contains a connection string referencing your old database name.
• You can locate these strings by searching for keywords like "DSN", "SERVER", or "DATABASE" within your queries.
• Once identified, simply replace the old database name with the new one.
• While effective, this approach can be tedious for a large number of queries.

2. Use a shared parameter file:

• This method involves storing the database name in a separate file, like a text file (.txt) or Excel sheet, and accessing it within your queries.
• Create a dedicated cell or line in your file to store the database name.
• In your ODBC queries, use a function like TEXTQUERY or SUBSTITUTE to dynamically reference and replace the placeholder for the database name with the value from your shared file.
• This approach allows you to easily update the database name in one place, and the change will automatically reflect in all your queries.

3. Leverage VBA macros:

• This method involves writing a macro in VBA (Visual Basic for Applications) to automate the process of updating the database name across all your queries.
• The macro can loop through each query, parse the connection string, and replace the old database name with the new one.
• While requiring some coding knowledge, this approach offers the most flexibility and automation for complex scenarios.

Additional tips:

• Before making any changes, backup your original spreadsheet and queries.
• Test your queries after updating the database name to ensure they function correctly.
• Consider using descriptive variable names for the database name in your shared file or macros for better clarity.

Choose the method that best suits your comfort level and technical expertise.

I hope the information above has been helpful. Please consider remembering me in your prayers. May peace be upon you