import or merge data

[Guest]

I have a table that has several different columns. I also have another table
that has some of the same columns. I want to merge or import the databases,
so they are together even if some columns are blank
for example
table one has name address phone location type amount due

table two has name address phone

I want table two to merge into one, maintaining all the columns of one, even
if empty.

How do I do this?

 

[Guest]

Hi Rick

It's up to you but I would not merge the tables or you will have name and
address twice. Of course if you sit and think for a while about the formula
you could use an append query to merge some infomation - BUT I would do this
on a copy DB.

Better idea
Why not delete the name and address info from tbl2 and the phone info from
tbl1. Then you could link the 2 tables. The reason for this is that some
people may have more than 1 phone or location (which could also be another
table).

You may want to look at the data and see how it could be stored in the best
manner (sorry don't know the right english word so "best" will have to do)

HTH