Accessing External Database

[Guest]

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

 

[Guest]

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

 

[Guest]

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