Database Reference
In-Depth Information
In this exercise, you'll export an Access table to another Access database and to an Excel
workbook. Then you'll export the table as both a formatted and an unformatted text file.
SET UP
You need the GardenCompany10 database you worked with in the preceding
exercise to complete this exercise. Create a blank desktop database named Exported in
the Chapter10 practice file folder, and close the open table. Then if necessary, open the
GardenCompany10 database, and follow the steps.
1
In the
Navigation
pane, in the
Tables
group, click
Suppliers
.
TIP
When you export an entire table, there is no need to open it first.
2
On the
External Data
tab, in the
Export
group, click the
Access
button to start the
Export - Access Database
wizard.
3
On the wizard's first page, click
Browse
.
4
In the
File Save
dialog box, navigate to the
Chapter10
practice file folder, click
Exported
, and then click
Save
.
5
In the
Export - Access Database
wizard, click
OK
, which opens the
Export
dialog box.
You can export the table's structure and data or only the structure.
6
With
Suppliers
displayed in the
Export Suppliers to
box and
Definition and Data
selected in the
Expor t Tables
area, click
OK
to export the selected table.
7
On the
Save Export Steps
page, click
Close
.
Let's check that the export was successful.
8
Display the
Exported
database in a separate instance of Access.