I am currently experiencing an issue while connecting MySQL via ODBC in Excel’s Microsoft Query. Specifically, when loading tables, the original table names are being altered by appending a “_0” postfix. For instance, a table named “employee” appears as “employoo_0”.

To address this behavior, I have already attempted to use both the 32-bit and 64-bit MySQL ODBC drivers, but the issue persists. I am seeking a solution to maintain the original table names without any modifications.

Steps taken include reviewing and verifying the table names in the MySQL database to ensure they do not already contain any postfixes like “_0”. Additionally, I have checked and adjusted settings within the ODBC connection configuration and Excel’s Microsoft Query options, yet the problem remains unresolved.

Considering these efforts, I am exploring further options such as updating to newer versions of the MySQL ODBC driver or manually specifying SQL queries to directly access tables, bypassing automatic table name handling in Microsoft Query.

If you have any insights or recommendations on resolving this issue effectively, or if there are specific settings or updates for the MySQL ODBC driver that address table name handling, I would appreciate your guidance