Importing Tables Question

[Lanacan]

I'm wondering if you can have one access database through a script or
macro import data from a table in a different access database?

Example:

You have two databases DB1(contains table1) and DB2(contains table2 and
table3). I want DB2 on command to pull the data from table1 in DB1,
store it in table 3 and then compare it through a query with table2 in
DB2. Then take the results of the query and append it to the original
table1 in DB1 with out losing the original data that was stored in
DB1's table1.

Is this possable?

[Rick Brandt]

Lanacan wrote:

I'm wondering if you can have one access database through a script or
macro import data from a table in a different access database?

Example:

You have two databases DB1(contains table1) and DB2(contains table2
and table3). I want DB2 on command to pull the data from table1 in
DB1, store it in table 3 and then compare it through a query with
table2 in DB2. Then take the results of the query and append it to
the original table1 in DB1 with out losing the original data that was
stored in DB1's table1.

Is this possable?

You can just link to table1 in DB1 and then directly compare the link to
table2 in DB2. Table3 isn't needed at all.

File - Get External Data - Link Tables...

[Rick Brandt]

Lanacan wrote:

I'm wondering if you can have one access database through a script or
macro import data from a table in a different access database?

Example:

You have two databases DB1(contains table1) and DB2(contains table2
and table3). I want DB2 on command to pull the data from table1 in
DB1, store it in table 3 and then compare it through a query with
table2 in DB2. Then take the results of the query and append it to
the original table1 in DB1 with out losing the original data that was
stored in DB1's table1.

Is this possable?

You can just link to table1 in DB1 and then directly compare the link to
table2 in DB2. Table3 isn't needed at all.

File - Get External Data - Link Tables...