Entourage validating and copying link data
For example, the destination field might have the Field Size property set to Byte in an Access database but the source data contains a value greater than 255.
Correct the values in the source file and try importing again.
This topic explains in detail how to import or link to Excel data from Access desktop databases.
If your goal is to store some or all of your data from one or more Excel worksheets in Access, you should import the contents of the worksheet into a new or existing Access database.
When you import data to a new table or append data to an existing table, Access does not enable support for multiple values in a field, even if the source column contains a list of values separated by semicolon (;).
The list of values is treated as a single value and is placed in a text field.
Records that you are importing might contain duplicate values that cannot be stored in the primary key field of the destination table or in a field that has the Indexed property set to Yes (No Duplicates).
For troubleshooting information, see the section Troubleshoot missing or incorrect values.
After you have corrected all known problems, repeat the import operation.
The results of a calculated column or cells are imported, but not the underlying formula.
Tip: While you are troubleshooting the results, if you find just a few missing values, you can add them to the table manually.
Conversely, if you find that entire columns or a large number of values are either missing or were not imported properly, you should correct the problem in the source file.