AccessToExcel

AccessToExcel from Withdata Software is a tool for exporting data from Microsoft Access MDB and ACCDB databases to Excel XLS and XLSX files. Neither Access nor Excel has to be installed. A single table can be exported, several similar tables can be merged into one sheet, or many tables can become sheets of one workbook or separate files.

Moves Access data into Excel workbooks in a few steps.

Instead of whole tables, the results of a custom SQL query can be exported, and columns can be mapped and date formats set. A command-line mode allows scheduled exports with dynamic file names. The standalone AccessToExcel has been folded into the Withdata DBToFile product, which offers the same Access to Excel function together with other databases and file formats.

Features:

• Export of Access tables to XLS and XLSX
• Several tables into one sheet or workbook
• Batch export, one file per table
• Export of SQL query results
• Column mapping and date formats
• Command line for scheduled exports