Hello,

I am using Access 2002. I would like to append data from one Access
database into another Access database.

Can anyone provide me with guidance in this using vba?

Very Much Appreciated,

M. Wilson

Need a little bit more information ... but you can do this without code ...

If you are looking to simply copy data from one database to another you can
use append queries. You'll need to use linked tables to do this.

Shaun Beane

"M. Wilson" wrote:

> Hello,
>
> I am using Access 2002. I would like to append data from one Access
> database into another Access database.
>
> Can anyone provide me with guidance in this using vba?
>
> Very Much Appreciated,
>
> M. Wilson

Hi Shaun,

Thanks for the reply. This process is taking place in a large block of
code. My users need to update over 90 tables with the click of a button.
All of the tables are in separate databases so I would like to do this via
vba.

Last year, I actually did it the way that you suggest. I had over 100
queries and linked tables but it was ackward and took up way too much space.

Let's say the table name is Table1 and the database is named DB1. How do I
link to Table1 in DB1 from DB2? Keeping in mind that I will grad the data
from Table1 and append it to a table in DB2.

Thanks,

M. Wilson

"Shaun Beane" wrote:

> Need a little bit more information ... but you can do this without code ...
>
> If you are looking to simply copy data from one database to another you can
> use append queries. You'll need to use linked tables to do this.
>
> Shaun Beane
>
> "M. Wilson" wrote:
>
> > Hello,
> >
> > I am using Access 2002. I would like to append data from one Access
> > database into another Access database.
> >
> > Can anyone provide me with guidance in this using vba?
> >
> > Very Much Appreciated,
> >
> > M. Wilson