data merge

mcnews

Guest

Posts: n/a

8th May 2012

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

« Re: newbie's question | Struggling! Please help! »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
mail merge excludes my headers and critical data in Word merge	=?Utf-8?B?Tml4?=	Microsoft Excel Misc	0	21st Apr 2006 08:35 PM
how do i get my mail merge to update the data source at each merge	=?Utf-8?B?U3RlZWxfTW9ua2V5?=	Microsoft Excel Misc	0	30th Nov 2005 09:41 AM
Merge Outlook data into Excel like Mail Merge	=?Utf-8?B?TWFyc2hhbGxAQ0tT?=	Microsoft Outlook Contacts	0	23rd Mar 2005 04:39 PM
DataSet.Merge where data being merge has less rows than the oringal source	Dan Hibbert	Microsoft ADO .NET	2	20th Jan 2005 07:35 PM
Mail Merge using MS Word and Outlook-Unable to merge Contacts data	John O'Grady	Microsoft Outlook Contacts	0	24th Jul 2003 12:09 PM