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!

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

"frustrated user" wrote:

> 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!

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

/amelia

"Dj" wrote:

> 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
>
> "frustrated user" wrote:
>
> > 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!

Hi everybody,

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

Thank u lord,
KD

"aaearhart" wrote:

> I too am having this issue and it's really bumming me out.
>
> /amelia
>
> "Dj" wrote:
>
> > 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
> >
> > "frustrated user" wrote:
> >
> > > 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!

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...
--
Clement E


"Ramesh" wrote:

> Hi everybody,
>
> I am the fourth one suffering from the same problem. Any help?
>
> Thank u lord,
> KD
>
> "aaearhart" wrote:
>
> > I too am having this issue and it's really bumming me out.
> >
> > /amelia
> >
> > "Dj" wrote:
> >
> > > 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
> > >
> > > "frustrated user" wrote:
> > >
> > > > 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!