Excel Imports into Access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Den - 18 Sep 2004 04:55 GMT

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

Reply to this Message

- 18 Sep 2004 12:30 GMT

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.

>-----Original Message-----
>I'm importing a named range from several identically
[quoted text clipped - 13 lines]
>
>.

Reply to this Message

- 18 Sep 2004 13:13 GMT

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.

>-----Original Message-----
>hi,
[quoted text clipped - 23 lines]
>>
>.

Reply to this Message

Bob - 14 Jan 2005 17:49 GMT

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

> I'm importing a named range from several identically
> formatted Excel files into Access. I can successfully
[quoted text clipped - 10 lines]
>
> Dennis Cornwell

Reply to this Message