January 23, 2017

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

Post a Comment

Featured Post

The new Dell XPS 13’s overall design is 30% thinner and lighter than its predecessor

The new Dell XPS 13 has twice the performance of the XPS 13 launched in 2015, as well as improved battery life that should enable the model...