Free E-Books

n Numeric data being entered is too large for the field size of the Access table.
n A row in a text file or spreadsheet may contain more fields than the Access table.
n The records being imported have duplicate primary key values.
The Import Errors table
When errors occur, Access creates an Import Errors table you can use to determine which data
caused the errors.
Open the Import Errors table and try to determine why Access couldn??™t import all the records. If
the problem is with the external data, edit it. If you??™re appending records to an existing table, the
problem may be with the existing table; it may need modifications (such as changing the data types
and rearranging the field locations). After you solve the problem, erase the Import Errors file and
import the data again.
Access attempts to import all records that do not cause an error. If you re-import the
data, you may need to clean up the external table or the Access table before re-importing.
If you don??™t, you may have duplicate data in your table.


Pages:
1149 1150 1151 1152 1153 1154 1155 1156 1157 1158 1159 1160 1161 1162 1163 1164 1165 1166 1167 1168 1169 1170 1171 1172 1173