Open (64-bit) or Excel → Get Data → ODBC → Enter your DSN name. If you see table previews, you’re done.
The IP address or hostname of the database server. Port: (e.g., 3306 for MySQL, 1433 for SQL Server). Authentication: Your username and password. how to install odbc driver in windows
Select the specific database schema from the dropdown menu. 5. Test the Connection Open (64-bit) or Excel → Get Data →
If you cannot save a System DSN, ensure you launched the ODBC Administrator with Administrative privileges. 3306 for MySQL