Chapter 17: Importing and Exporting Data .................................................................................
611
The Export group includes the following options:l Saved Exportsl (^) Excel
l Text File
l (^) XML File
l PDF or XPS
l (^) E-mail
l Access
l (^) Word Merge
l More Click this button to open the More drop-down list, which has the following options:
l (^) Word
l SharePoint List
l (^) ODBC Database
l HTML Document
l (^) dBase File
Obviously, Microsoft has well-prepared Access for its role as a “landing pad for data.”
Importing External Data
An import copies external data into an Access database. The external data remains in its original
state, but, after the import, a copy exists within Access. When you import a file (unlike when you
link tables), you copy the contents from an external source into an Access table. The external data
source is not changed during the import. No connection to the external data source is maintained
once the import process is complete.
You can import information to new or existing tables. Every type of data can be imported to a new
table. However, some types of imports — such as spreadsheets and text files — may have to be
imported into existing tables, because text files and spreadsheets don’t necessarily have a table
structure compatible with Access.
Importing from another Access database
You can import items from a source database into the current database. The objects you import
can be tables, queries, forms, reports, macros, or modules. Import an item into the current Access
database by following these steps:
- Open the destination database you want to import into.
In this case, open the Chapter17_1.accdb database.