Re: Error while connecting MySQL
If you want to connect MS Excel via ODBC you need to use the following steps:
1. Install MySQL Connector/ODBC 8.0 if it is not installed already.
2. Create a new Data Source in ODBC Data Source Administrator to connect
to MySQL Server.
3. In Excel go to:
Data -> Get Data -> From Other Sources -> From ODBC
4. Select the data source (created in step 2) in the list.
5. The list of databases and tables will be shown.
Subject
Written By
Posted
Re: Error while connecting MySQL
July 20, 2023 03:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.