Database Reference
In-Depth Information
TIP
You can change the name and format in the File Save dialog box, or you can edit
the name and select a different format in the wizard.
12
Select the
Export data with formatting and layout
check box and the
Open the
destination file after the export operation is complete
check box. Then click
OK
,
which starts Excel and opens the exported workbook.
The Suppliers table has been exported to the Suppliers sheet in the workbook.
13
Close the workbook and Excel, and then on the
Save Export Steps
page of the
Export - Excel Spreadsheet
wizard, click
Close
.
TIP
If you want to make the data in a table available in Outlook, you can export
the table as an attachment to an email message by clicking the Email button in the
Export group.
Now let's export data from Access to a text file.
14
With the
Suppliers
table open in
Datasheet
view, on the
External Data
tab, in the
Export
group, click the
Tex t File
button to start the
Export - Text File
wizard.