Database Reference
In-Depth Information
The specific formats available depend on the object you are exporting, as shown in the
following table.
Database object
Valid export format
Table
ACCDB, XLS, XLSB, XLSX, SharePoint List, PDF, XPS, RTF, TXT, XML, ODBC,
HTML, Word Merge
Query
ACCDB, XLS, XLSB, XLSX, SharePoint List, PDF, XPS, RTF, TXT, XML, ODBC ,
HTML, Word Merge
Form
ACCDB, XLS, XLSB, XLSX, PDF, XPS, RTF, TXT, XML, HTML
Report
ACCDB, XLS, PDF, XPS, RTF, TXT, XML, HTML
TIP To display a list of the export file formats available for a specific Access object, right-
click the object in the Navigation pane, and then point to Export.
Like the import process, the export process for most file types is orchestrated by an easy-
to-follow wizard by using these standard steps:
1 In the Navigation pane, select the object you want to export.
2 On the External Data tab, in the Export group, click the button for the program or
type of file you want to create, which starts the Export wizard.
3 On the wizard's first page, depending on the export format, specify one or all of the
following:
The destination file's location and format
Whether to export just data, or data with formatting
Whether to open the file when the export process is complete
Whether to export only selected records
Click OK .
4
When the export process is complete, you return to the Export wizard, which gives you the
opportunity to save the export steps so that you don't have to repeat them for future simi-
lar export processes. The process for saving export steps is nearly identical to the process
for saving import steps.
The steps for exporting Access database objects in PDF or XPS format or as email attach-
ments are slightly different but are still quite automated. You can also use an Access table or
query as the data source for the Word 2013 mail merge process; this process is not covered
in this topic, but if you are familiar with mail merge in Word, it is relatively straightforward.
Search WWH ::




Custom Search