Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

how to combine name and address information from 2 databases

Discussion in 'Information Technology' started by jp, Nov 17, 2005.

  1. jp

    jp
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    SAD-Sant Samaj Combine Sweeps SGPC Elections Sikh Sikhi Sikhism Sep 19, 2011
    SciTech 3,000 images combine for Milky Way portrait Breaking News Nov 2, 2009
    Sikh News SAD-BJP combine sweeps civic polls in Punjab (Outlook India) Breaking News Aug 8, 2007
    Getting A Sikh Name Questions and Answers Jul 29, 2016

  3. Phillip Windell

    Phillip Windell
    Expand Collapse
    Guest

    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" <jp@discussions.microsoft.com> wrote in message
    news:370AD88E-6DB2-426D-BFD8-69205AF8F0C6@microsoft.com...
    > 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.
     
  4. jp

    jp
    Expand Collapse
    Guest

    o.k.
    so first I make sure I have the two tables in my database.
    Then you mention an append query.
    I don't see the mention of append on my query menu.

    "Jackie L" wrote:

    > You can create a table in Access with the fields you need. Either link to
    > the old data or import into your database into separate tables. Then,
    > create two Append queries, one for each linked/imported table. Append the
    > data to the new table and fields that you created.
    >
    > Hope this helps.
    >
    > "jp" wrote:
    >
    > > 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.
     

Share This Page