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: 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: Form Letter, Spreadsheet.

Microsoft Word: See Mail Merge in Word.

Microsoft Excel: See Excel.