importing data from access to access

[JohnE]

Hello. I have a situation in which the users are wanting to import the data
(not the table) from other Access2003 dbs to the one they are working on.
There are 3 other db's that have tables that the users will want to bring the
data from and combine/append into one (1) table. The one issue that could be
a problem is the overall combined table has more fields then what each of the
importing tables have. Each of the imported tables makeup a portion of the
overall combined table fields until all the fields are used.

This is confusing, I know. But when I see the tables and review it,
eventually it looks okay.

I am at a loss in how to import the data from another db and ask for help
from the discussion group. Or if there are there any sample/examples on how
to accomplish this?

Thanks.
..... John

 

[JohnE]

My apologies for this added part. The importing needs to be done thru coding
and not the external data wizard.
.... john

 

[KARL DEWEY]

Link the tables - click on menu FILE - Get External Data - Link Tables.
After you have linked the tables then build a select query joining them and
test. When test indicates good then change to an append query by clicking on
icon bar that shows two data sheets and a down arrow. Select Append and run
it.