Export Access Table to an External File

Access allows you to easily export tables, queries, reports, forms, macros, and modules to several different file formats both internal and external to Office. The different formats are shown and accessed by the External Data / Export menu.

Easy export method: select the table, query, etc. that you wish to export in the Navigation Pane, and right click. In the option menu select export, and then highlight the format that you wish to export to. The wizard will prompt you from there depending on which format you select. Note: export formats that are not available for the Access element that you choose to export will be grayed out.