Create a table from 3 tables of 3 different bases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Telesphore - 11 Nov 2005 05:01 GMT

How to create a table with the fields Name, first name, address, etc,
starting from 3 tables of 3 different bases and avoid repetition of names?

Thank you for the assistance.

Reply to this Message

Allen Browne - 11 Nov 2005 05:12 GMT

This will be almost impossible to do without duplicates, because the data
will not be the same. For example, these addresses would be treated as
different:
14/3 First Ave
14/3 First Avenue
Unit 14 3 First Avenue
and so on.

If you want to try anyway, you could link (or import) the 3 tables, and
create a UNION query based on the results. The UNION automatically
de-duplicates. Then change it to an Append query, to add the results to a
new table.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How to create a table with the fields Name, first name, address, etc,
> starting from 3 tables of 3 different bases and avoid repetition of names?
>
> Thank you for the assistance.

Reply to this Message

Oka - 11 Nov 2005 21:55 GMT

Thank you,

I will try.

Telesphore

Reply to this Message