Import Error from Excel

[Jillybean]

I am importing data from excel from multiple files. The files have the exact
same headings. The first file imports just fine but when I try to import the
2nd file to the existing table, the file does not import. The errormessage
states that "an error occurred while trying to import the file. The file did
not import." The files do contain drop down boxes from a list but the
options are exactly the same. Please help.

 

[Jeanette Cunningham]

Hi Jillybean,
to find out more about what that error is trying to tell you, try the
following.
Import the 2nd file to a new table.
Note it there are any errors with this import.
Create an append query to take the data from the new table and append it to
the existing table that has the data from the 1st import.
Look for reasons why the append query doesn't append all the records.
There may be a problem with duplicates, or maybe a problem with validation
rules or field length rules.
Post back if you get stuck.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Jillybean]

Thank you so much for your response. The append query works with no errors.
It gets me to what need but it is adding an extra step versus just being able
to import it into the table during the first step. Any idea why?

 

[Jeanette Cunningham]

Fields in tables have properites like the data type, the field length,
validation rules.
There can be unique indexes on one or a combination of fields.
All of the above can stop your import into your existing table, but allow
import to a new table.

It takes some time, but if you want to learn why, open both the tables in
design view and compare field for field the properties for each field in
both tables.
This will most likely show you why the import won't just go into the
existing table.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia