Here we describe connectivity to Excel with a MySQL server database and import a table or data into Excel. So we have to use this technique; first we have to connect Excel to the MySQL database with the help of the my ODBC connector 3.51 and import a table into Excel sheet. In this table we have to display data and edit data in the table. So, we have a table in our database and connect through the connector.
We have to follow these steps which are given below:Step1 : Install driver for MySQL Connector/ODBC. Step 2 : Go to start menu click->control Panel->Administrative Tools->Data Sources(ODBC).Step 3 : In the Data Sources display a window and click the Add Button. It contains all the connection information.Step 4 : After clicking on the add button, open the create new data source window and select the data source and click finish. We have to use the MySQL database and find it to see the MySQL ODBC 3.51 driver and select it.
Step 5 : After finish this window open the ODBC data source configuration.Step 6 : After filling in the entries test the connection.Step 7 : After successfully making the connection, see the ODBC data source administrator; find the MySQLDSN.Step 8 : Choose the data source and click ok.Step 9 : We have to see the available tables and columns from the database.Step 10 : Select a table and click next; all the columns will appear in this window.Step 11 : In the query wizard see the following options and select one of them.Step 12 : After finishing the wizard, see the table in Excel. The table we were working with had seven fields.ResourcesHere are some useful resources:
Working With the Encryption Password Function in MySQL
Case When Select Command in MySQL Server