Access 2016 Intermediate

Lesson 7 - Using Advanced Database Features

Access 2016

I MPORTING D ATA



Discussion

You can import data from one or more external data sources. The external data source can be another Access database, a database created in a different program (such as dBASE or Excel), ASCII text, or an HTML data table.

When you import data from a spreadsheet, another type of database, or ASCII text, a wizard opens to step you through the process. The data format in the external data source does not change. Use Access to add, edit, or delete the data.

If the external data source is an Access database, you can also import database objects such as queries, reports, and forms. This option allows you to copy a query from one database to another and modify it as necessary, rather than creating a new one. In addition, you can easily copy standard reports and forms between databases.

Using the Import Text Wizard

NOTE If the table you import has a lookup field, you should also import the source of the information for the lookup field.

Page 118

OFFICEPRO, Inc.