Microsoft Office Tutorials and References
In Depth Information
Importing or Linking to Data
2. Select the check box(es) for the table(s) whose links you want to
3. If you want Access always to ask you where the files are, select the
Always Prompt for New Location check box.
4. Click OK.
Access gets the updated data for the selected tables, using the external
file listed in the table. If the external file isn’t found, you see the Select
New Location Of dialog box, where you can specify the new location. If
more than one table wasn’t found, Access searches the new location for
all the missing tables.
Cleaning up your imported data
If you import large amounts of data, you may need to clean it up a bit to
make it efficient for use in Access. (If you have any doubt about what clean
data looks like, review Book I, Chapter 3.)
One useful tool for cleaning up imported data is the Table Analyzer Wizard.
This wizard looks for repeated data to determine whether to break a table
into two or more tables. The various import wizards offer to run the Table
Analyzer Wizard. You can also run this wizard by clicking the Analyze Table
button in the Analyze group on the Database Tools tab of the Ribbon.
If you decide not to use the Table Analyzer Wizard, you may want to inspect
your data for duplicate data. The primary key field can’t have duplicate data.
Your new table may need relationships defined with other tables in the
database. (See Chapter 6 of this minibook for more information on relationships.)
You may also want to edit the table name or field names, as well as fine-tune
some fields. You can use Design view to edit the data type and properties (as
explained in Chapter 2 of this minibook).