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). 


Popular posts from this blog

How to get Active Transactions and Locks from MySQL

Example of a PAC file