Error when importing a table

M

Matt W.

Im trying to import an excel spreadsheet into an existing table in Access. I
have 2 questions, 1) does this just replace the data already in the access
table? and 2) I get an error that states "an error occurred while trying to
import my file. Any help would be great
Thanks!
 
M

MacDermott

No, it will not replace existing data.
If there are no key conflicts, your new data will be appended to the old.
If there are conflicts, the old data is retained.

If there are errors importing your file, Access often creates a table with
your table name and _ImportErrors, where you can learn something of the
problems.

HTH
 
Top