Database Reference
In-Depth Information
11 In Excel, select cells A1:H6 of the active worksheet, and on the Home tab, in the
Clipboard group, click the Copy button.
12 Switch back to Access, right-click in the Tables group of the Navigation pane, and
click Paste .
13 When Access asks whether the first row of data contains column headings, click Yes .
14
Click OK to acknowledge that the import process was successful, and then notice that
the new Shippers table has been added to the Tables group of the Navigation pane.
15
Double-click the Shippers table to open it, and verify that all records were
successfully copied.
CLEAN UP Exit Excel. Then close the Shippers table and the GardenCompany10
database.
Key points
Importing information into Access 2013 from other programs is an easy way to add
data without reentering it.
If data is actively maintained in another program and you want to work with it in
Access, you can link the Access database to the data without actually importing it.
You can export information from an Access database in a variety of formats, depend-
ing on the object you are exporting.
Copying and pasting information from an Access database is often the easiest way to
make the data available to other Office programs.
If the data in other Office programs is set up appropriately, you can copy and paste it
into an Access database.
10
Search WWH ::




Custom Search