January 23, 2017
How to Use Connector/ODBC with Microsoft Word, Excel or Access to connect to MySQL
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).
To redeem: 1. Sign up for Google Apps 2. Go to your billing settings 3. Choose your payment plan 4. Enter your promo code ...