Database Reference
In-Depth Information
In the sections that follow, we discuss some of the issues to bear in mind when exporting
data to a specific type of file.
Exporting to other Access databases
It is very simple to export any single object from one Access 2013 database to either another
Access 2013 database or to a database in an earlier version of Access. You can't, however,
export multiple objects in one operation.
Exporting to Excel worksheets
You can export a single table, form, report, or query from an Access 2013 database to an
Excel 2013 workbook, or to a workbook that can be opened by earlier versions of Excel.
When you export a table that contains a subdatasheet or a form that contains a subform,
Access exports only the main datasheet or form. To export a subdatasheet or subform, you
must perform another export operation on that object.
To combine multiple Access objects into a single Excel workbook, first export the individual
objects to different workbooks. Then merge all the worksheets in Excel.
Exporting to Word documents
If you need to move a table or the results of a query to an existing Word document, it is
often easiest to simply copy and paste the records from the datasheet. But if you want to
work with the contents of a report in Word, you need to export the report.
When you export information from Access 2013 to Word, Access creates a Rich Text Format
(RTF) document, which can be opened by Word and several other applications.
10
Exporting to text files
Tex t files are the lowest-common-denominator file format. Most applications can open, dis-
play, and save information in text format. The downside to text files is that they don't con-
tain any formatting information, so they look consistently plain in all applications.
Depending on what type of content you are trying to export from a database, you might
have the option to export the layout with the data. If you select this option, the unfor-
matted text will be arranged in the text file much as it is in the Access object. If you don't
choose this option, the information will be saved in either delimited or fixed-length lines.
