Using Data in Other Programs
You can use the data in your MySQL / MariaDB database in a number of ways.
Export: Export a Standard Reports or User Query as a .txt (text) or .xls (Excel) file.
ODBC Connection: An ODBC connects you real-time to the raw data. This is very advanced. You might use this from Access for very customized reports combining data from multiple tables.
OpenOffice: Openoffice.org is an open source alternative to Microsoft Office. It includes a word processor and a spreadsheet as well as other tools. The following sections address using data in OpenOffice either from a text file or through an ODBC connection: OpenOffice.org Form Letter, OpenOffice.org Spreadsheet.
Microsoft Word: See Mail Merge in Word.
Microsoft Excel: See Excel.