I know the headers aren't mismatched

  • Thread starter Thread starter JK
  • Start date Start date
J

JK

I keep getting 'an error occurred trying to
import '<filename>'. The file was not imported.' error
when importing into an existing table. The only answer I
keep getting is that the headers are mismatched so the
field information isn't synced up with data type. But I
know thats not the case. Any ideas?
 
Just a guess, but are you trying to import the data to an existing table,
one that was created during an earlier import? And one for which you asked
ACCESS to create a primary key field for you? If yes, then ACCESS is trying
to find the autonumber field in your file, and isn't finding it...and thus
throwing that error at you.
 
You are correct. I tried removing the primary key and
attempting the import again same issue. I also attempted
using a resolution that the knowledge base has on the
issue for Access 97 by creating an append querry but for
some reason Access 2002 doesn't like SELECT in the INSERT
INTO statement. I at the point where I guess this is just
a limitation of the JET engine. Kind of pain the reason
for the database was to get away from extra data entry.
Any suggestions?

Thanks,

JK
 
What I suggest is that you import to a new table, and then run an append
query that will copy the data to the existing table.

Without seeing your SQL statement, I can't offer advice for how to fix it.
If you post it, I'm sure we can overcome the error.
 
Back
Top