MySQL ODBC Access

Download and install the x64 version of Visual Studio: The latest supported Visual C++ downloads (microsoft.com)

Go to: https://dev.mysql.com/downloads/connector/odbc/

Download the Windows 64-bit MSI installer (currently hosted at https://dev.mysql.com/downloads/file/?id=501047)

Install, "typical" settings and defaults are fine

Go to Windows "ODBC Data Sources (64-bit)"

User DSN Tab, click Add

Select "MySQL ODBC Unicode Driver"

 

Connection Parameters:

Data Source Name may vary for the application.  Millwork-Net (Victory Millwork) uses "MW Net"

Description can be blank

TCP/IP Server: varies, Millwork-Net is "millwork-net.lyndendoor.com"

Port should remain 3306

User and password should be provided

Click Test, it should work and the database dropdown will populate

Database varies, often there is only one option other than information_schema.  Millwork-Net is "mwnet"

 

 

If someone later complains about excel acting strange, specifically something like "it says I have no visible tables"... this is an issue with how Microsoft Query identifies tables, and there's a simple fix

https://www.excelhowto.com/microsoft-query-error-this-data-source-contains-no-visible-tables/