Import multiple Excel files into the same Access db?

[frustrated user]

I receive data daily in Excel format. I would like to maintain one database
for those and update it with the Excel information on a daily basis. I have
tried to do it, unsuccessfully ( Any help is welcomed!!! thanks!

 

[Dj]

I'm having the exact same problem. The first excel file I emport works fine,
then I try importing the next file and I get an undefined error. It just
tells me "there was an error; file not imported". All the excel files are
the exact same format (in fact, they are exported from a different .mdb).
I've even tried imported the exact same data to the existing table and still
no luck.

If anyone can help, you'd be helping two "frustraded users"!

Thanks! Dj

 

[aaearhart]

I too am having this issue and it's really bumming me out.

/amelia

 

[Ramesh]

Hi everybody,

I am the fourth one suffering from the same problem. Any help?

Thank u lord,
KD

 

[Clement]

Make me number 5!!
I need to update my Acess tables from an Excel spreadsheet i frequently
recieve and have tried by doing the following: I imported the Excel data into
a new table (say 'TableN'). From here I made append queries into the tables
using my TableN.
But i still run into errors. Perhaps im doing something wrong during the
append queries and need to figure it out.
But there has to be a better way of moving this data into the table from
Excel...