Appending data from table to table

[Bob]

Hi,

This should be simple but I can't get it to work properly. I want to append
data from one Access Db to the data in another. The tables in both are
exactly the same. When I do it the importing Db is creating a new table in
the Db with the data in it. I want it to append the data to the existing
table thereby accumulating the data which supports a few forms.

Thanks,
Bob

 

[John W. Vinson]

Hi,

This should be simple but I can't get it to work properly. I want to append
data from one Access Db to the data in another. The tables in both are
exactly the same. When I do it the importing Db is creating a new table in
the Db with the data in it. I want it to append the data to the existing
table thereby accumulating the data which supports a few forms.

Thanks,
Bob

Use File... Get External Data... LINK rather than File... Get External Data...
Import; and then run an Append query to append the remote table's data to the
local table.

Might there be duplicates, particularly in the Primary Key? If so you'll need
to be careful how you do the append.

 

[Bob]

Thanks John

Use File... Get External Data... LINK rather than File... Get External
Data...
Import; and then run an Append query to append the remote table's data to
the
local table.

Might there be duplicates, particularly in the Primary Key? If so you'll
need
to be careful how you do the append.

 

[Bob]

Hmm... I'm using Access 2007 so I don't see the old fashion File, etc.
options.

Under the External Data tab I can Import from a number of options but the
Link option seems to want to change the data in both as changes are made in
one.

What I'm trying to do is work in one db and then move the changes over to
the second db or master so the original can be wiped and re-used as a blank.
This process will be repeated as data is entered. If the changes made in A
or B are reflected in both this won't work. Would this be the same in your
example?

Thanks

 

[John W. Vinson]

Hmm... I'm using Access 2007 so I don't see the old fashion File, etc.
options.

Under the External Data tab I can Import from a number of options but the
Link option seems to want to change the data in both as changes are made in
one.

What I'm trying to do is work in one db and then move the changes over to
the second db or master so the original can be wiped and re-used as a blank.
This process will be repeated as data is entered. If the changes made in A
or B are reflected in both this won't work. Would this be the same in your
example?

I guess I've got to break down and install 2007, maybe on my old machine
(which I'll need to Freeman and reload). Sigh.

I suppose it would be the same. If you link it will indeed "want to change the
data in both as changes are made in one", but you won't be making changes to
the linked table. Instead you will create a new Append Query based on the
linked table and append the data into the local table. The linked "table" can
then be deleted (it's just clearing the connection, not deleting any data).