How to Use Connector/ODBC with Microsoft Word, Excel or Access to connect to MySQL

You can use Microsoft Excel, Word to access information from a MySQL database using ODBC. 

Within Microsoft Excel or Word there are facilities to import data from MySQL database. 

See the following steps.

Step-1 : Be sure that your MySQL server is running. 

Step-2 : Create a new worksheet.

Step-3 : From the Data menu, click on 'From other sources' then click on 'Data Connection Wizard', the following window will come : 

Select 'ODBC DSN' and Click on 'Next' 

Step-4 : From ODBC data sources select 'MySQL' and click on 'Next' 

Step-5 : Now select databases and tables.

Step-6 : Let select database and table and click 'Next'. 

Step-7 : Input a name and description for your new Data Connection, and press 'Finish' to save. 

Step-8 : Select how you want to view this data in your workbook (e.g. Table, PivotTable Report etc).