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

Updated Coupons / promo codes for Google Apps for Work / Business

To redeem: 1. Sign up for Google Apps   2. Go to your billing settings  3. Choose your payment plan  4. Enter your promo code ...