How can I export data from ExpressMaintenance?

See Also: How can I import data into ExpressMaintenance?

Answer: ExpressMaintenance includes very flexible features for exporting data and interfacing with other data applications.  The easiest way to export data is by exporting from one of the grids or by using our built-in report builder.  In addition, because ExpressMaintenance is built upon the MS SQL database engine, data is fully accessible through common programs such as Excel and Access via ODBC (Open Database Connectivity).  There are dozens of applications that will allow you to query the SQL database and export data or import into other applications such as your accounting software.  You can also use our handy ExpressSQL to query tables and export results.

Grid Exports – Exporting Grid Data

Beginning with version 9, you can now export data contained in any grid by simply right clicking on the grid and selecting  ‘Export Grid Data’.  This option will present the export interface allowing you to select the desired output format.  Prior to choosing to ‘Export Grid Data’, you can perform a search to isolate the data you want to export.  Once the desired data is displayed in the grid, simply right click in the grid and select ‘Export Grid Data’.

Report Builder – Exporting Reports

To export the reports to your desired format, simply use your favorite report or design a report to query and present the data as desired.  Next, preview the report and then click the Print button.  When the print dialog is displayed, look in the lower section and check the Print to File option and then select the desired file type and file location.  Options include:

  • Adobe Acrobat pdf
  • HTML
  • Excel
  • Rich Text (Word)
  • Windows Metafile
  • JPEG
  • GIF
  • Text File
  • Bitmap

Report Builder – Exporting Raw Data

To export raw data using the report builder, simply use your favorite report or design a report to query the desired records and fields.  To export the raw data records, click on the Design Tab, click on File / Print To File Setup.  When the dialog screen appears, select the file name, type and bands and fields to be exported.   After closing the Print To File Setup screen, click on the Preview tab and then the Print button.  When the print dialog appears, check the Print to File option. If not already selected, select the file type of Text File and accept or change the destination file name.  Click the OK button and the data will be exported to the selected file.

ExpressSQL

A very simple and easy way to query data and export results is to use the ExpressSQL.  ExpressSQL is available from our website as a free download.  It provides a direct window to your data.  You can then export the raw data to numerous formats.   To download ExpressSQL install program – click here.

ODBC Applications

To export or interface with data via ODBC, simply use the ODBC Data Sources manager in the Control Panel to create a DSN link to the database.  Once connection is made, use your favorite interface application to access the data.  Microsoft Excel includes an optional MS Query tool that will allow you to quickly query data using a DSN / ODBC connection.  You can also use MS Access to query, view and edit data in the SQL database.