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:
    207
    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:
    197
    PC Datasheet
    Nov 5, 2003
  3. dan

    Merge Column Data

    dan, Jul 21, 2004, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    169
    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:
    180
    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:
    205
    John Vinson
    Apr 14, 2005
  6. Bruce Hawkins

    Access data to word mail merge

    Bruce Hawkins, Jun 24, 2005, in forum: Microsoft Access Getting Started
    Replies:
    1
    Views:
    263
    Duane Hookom
    Jun 25, 2005
  7. Guest

    how do i set up a mail merge using data from database

    Guest, Sep 29, 2005, in forum: Microsoft Access Getting Started
    Replies:
    3
    Views:
    193
    John Nurick
    Sep 30, 2005
  8. GA

    How to use an adp as a data source for mail merge.

    GA, Jun 13, 2006, in forum: Microsoft Access Getting Started
    Replies:
    2
    Views:
    409
Loading...