By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Importing Tables Question

P: n/a
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?

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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...
Nov 13 '05 #2

P: n/a
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...
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.