Excel Imports into Access 2003

[Den]

I'm importing a named range from several identically
formatted Excel files into Access. I can successfully
import one file into a new table but get an error when I
try to import a second file into the same table. If I
import the second file into new table, it works fine. The
error message is "An error occured while trying to import
file xx. The file was not imported."

Any thoughts on what the error is? No Import error file
appears.

Thanks!

Dennis Cornwell

 

[Guest]

hi,
imported excel files always go into a new table.
i would guess that you only option would be to do a union
query after import.

 

[Guest]

hi again,
i don't know where my mind was. i should have said an
append query. and in thinking about it, i would guess
that you might be able to automate the whole process with
a macro. you were a little vague on some points but it
might be worth looking into.
good luck.

 

[Bob]

Dennis,

Did you ever find a real solution to this? I'm having the same problem.
The help file clearly says you can import directly to an existing table. So
hopefully, you've figured and if you have can you post the solution. Thanks.

Bob