Error when importing a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing into existing table 5
Error while import Excel file to Access 6
Import to many to many table 7
Importing error 9
How to export table from outlook into ms access table? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Importing from Excel - error when adding to existing table 6
Importing Excel data into Access table 4

Back
Top