data merge

Discussion in 'Microsoft Access Getting Started' started by mcnews, May 8, 2012.

  1. mcnews

    mcnews Guest

    is there an easy way to merge data from one accdb to another? i get primary key violations every time. so i have to strip off the primary key from the data being imported. the problem comes when i need to import the related table that relies on the primary/foreign key relationship. i have to do a lot of manual editing to re-match up the records.
    gotta be a better way.
    tia,
    mcnewsxp
     
    mcnews, May 8, 2012
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Matthew

    Merge Access and Excel data?

    Matthew, Aug 25, 2003, in forum: Microsoft Access Getting Started
    Replies:
    4
    Views:
    149
    Ken Snell
    Aug 26, 2003
  2. Guest

    Word XP merge data source

    Guest, Nov 5, 2003, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    167
    PC Datasheet
    Nov 5, 2003
  3. dan

    Merge Column Data

    dan, Jul 21, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    133
    Guest
    Jul 22, 2004
  4. Guest

    Can I create a merge mail document that puuls data from 2 differe.

    Guest, Sep 22, 2004, in forum: Microsoft Access Getting Started
    Replies:
    0
    Views:
    149
    Guest
    Sep 22, 2004
  5. Guest

    In Access, how can I merge remote data into the same database?

    Guest, Apr 14, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    166
    John Vinson
    Apr 14, 2005
Loading...

Share This Page