MySQL Forums
Forum List  »  Connector/ODBC

Re: Error while connecting MySQL
Posted by: Bogdan Degtyariov
Date: July 20, 2023 03:00AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Error while connecting MySQL
July 20, 2023 03:00AM


Sorry, only registered users may post in this forum.

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.