importing data from access to access

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
My apologies for this added part. The importing needs to be done thru coding
and not the external data wizard.
.... john
 
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.
 
Back
Top