Database Reference
In-Depth Information
TIP
When information is imported into an existing table, all the field names and
data types must match exactly; otherwise, Access displays an error. If the structure
matches but data in a field is too long or has some other minor problem, Access
might import the record containing the field into an ImportError table, rather than
into the intended table. You can fix the problem in the ImportError table and then
copy and paste the record into the correct table.
12
In the lower-left corner of the page, click
Advanced
to open the
Employees Import
Speciication
dialog box.
10
You can make changes to the default settings in this dialog box.
TIP
If you want to import several files by using the same custom settings, you can
specify the settings and save them. Then as you open each file, you can click Specs
in this dialog box to apply the saved specifications.
