data merge

M

mcnews

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
 

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key 3
import data from excel 2003 to a table in an existing database 2
help with insert and disticnt query 5
add new record from linked table 9
Query based on multiple tables 2
Understanding Relationship Logic of Multiple Tables 2
Field Properties for Primary and Foreign Keys 3
Access 2007 to SQL 2008 - primary and foreign key types 3

Top