(mysql.info.gz) DocToExcel

 
 23.1.13.1 How to Retrieve Data from MySQL into MS-Word/Excel Documents?
 .......................................................................
 
 To retrieve data from MySQL to Word/Excel documents, you need to use
 the MyODBC driver and the Add-in Microsoft Query help.
 
 For example, create a database with a table containing two columns of
 text:
 
    * Insert rows using the `mysql' client command-line tool.
 
    * Create a DSN file using the ODBC manager, for example, `my' for the
      database that was just created.
 
    * Open the Word application.
 
    * Create a blank new document.
 
    * In the `Database' tool bar, press the `Insert Database' button.
 
    * Press the `Get Data' button.
 
    * At the right hand of the `Get Data' screen, press the `Ms Query'
      button.
 
    * In `Ms Query', create a new data source using the `my' DSN file.
 
    * Select the new query.
 
    * Select the columns that you want.
 
    * Make a filter if you want.
 
    * Make a Sort if you want.
 
    * Select `Return Data to Microsoft Word'.
 
    * Click `Finish'.
 
    * Click `Insert Data' and select the records.
 
    * Click `OK' and you see the rows in your Word document.
Info Catalog
(mysql.info.gz) Tools
(mysql.info.gz) MSDTS
automatically generated byinfo2html