S
Sharon
Can anyone tell me if it is possible to combine two access databases (with
same column headings) and how it is done.
same column headings) and how it is done.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
NetworkTrade
well the term "combine" is kind of vague.....
one can definitely import all the Forms/Queries/Tables of one database into
the other very easily.
one can link to another db's Tables.
one can merge/append Tables - presuming there is alignment of the
fields/properties....
so it really is not difficult at all, but there is more than one way to
"combine" and it kind of depends on your situation....
one can definitely import all the Forms/Queries/Tables of one database into
the other very easily.
one can link to another db's Tables.
one can merge/append Tables - presuming there is alignment of the
fields/properties....
so it really is not difficult at all, but there is more than one way to
"combine" and it kind of depends on your situation....
J
John W. Vinson
Can anyone tell me if it is possible to combine two access databases (with
same column headings) and how it is done.
Do you mean two *Databases* - different .mdb files, each with potentially many
tables, forms, reports, and other objects?
Or do you mean two *Tables* - since you refer to column headings I'd guess the
latter?
If two Tables, are these tables related to any *other* tables in your
database? If not, it's pretty easy; create a Query based on one of the tables,
select all the fields, and run an Append query appending the data to the other
table. If you have an Autonumber field just don't include it, and you'll get
(new and different) autonumber values for the appended records.
If you do have relationships to other tables and possibly duplicate primary
key values in the two tables, this can get to be a real chore. Post back with
more details if this is an issue.
John W. Vinson [MVP]