Import the tables (with the data) from the old database into the newer
database. Now with them all in the same database build your "queries"
according to what you want.
You can then also "normalize" the data, set table relationships, and get rid
of the redundancy of repeated information and make the whole thing more
efficient.
--
Phillip Windell [MCP, MVP, CCNA]
www.wandtv.com
-----------------------------------------------------
Understanding the ISA 2004 Access Rule Processing
http://www.isaserver.org/articles/ISA2004_AccessRules.html
Microsoft Internet Security & Acceleration Server: Guidance
http://www.microsoft.com/isaserver/techinfo/Guidance/2004.asp
http://www.microsoft.com/isaserver/techinfo/Guidance/2000.asp
Microsoft Internet Security & Acceleration Server: Partners
http://www.microsoft.com/isaserver/partners/default.asp
-----------------------------------------------------
jp said:
I have one older database with a list of clients and lots of other information.
I have a newer database with a list of clients and different information on
them.
I would like to combine the names and addresses so I will have one big list
from which to make mailing labels.