Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

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


 
 
  Published under the terms of the GNU General Public License Design by Interspire