Re: merging two .mdb files

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 02/12/05 

Date: Sat, 12 Feb 2005 21:05:07 +1300

Mark,

Do the records in the two tables have an ID field or some such, by which
you can identify which is the "same" record in each table? 

-- 
Steve Schapel, Microsoft Access MVP
Masoud wrote:
> I have two .mdb files with exactly the same structure 
> (Tables,...) but the second database has a data subset of 
> the first (base)data.
> 
>  I need to merge these two DBs into one database. I need 
> to do it through SQL, ADO via VBA code. My main problem is 
> writing the SQL statment to do following:
> 
> 1- chose a record from second database
> 2- Search the first (Base) database for that record
> 3- Compare the records
> 4- If they are different, replace the Base record with the 
> second DB record
> 
> I would appreciate any help.
> 
> Regards
> Mark Paydar
> .
> 
>

Relevant Pages

  • Re: merging two .mdb files
    ... See my reply in another newsgroup. ... > writing the SQL statment to do following: ... > 1- chose a record from second database ... > 4- If they are different, replace the Base record with the ...
    (microsoft.public.access.queries)
  • merging two .mdb files
    ... but the second database has a data subset of ... writing the SQL statment to do following: ... 1- chose a record from second database ... replace the Base record with the ...
    (microsoft.public.access.queries)
  • merging two .mdb files
    ... but the second database has a data subset of ... writing the SQL statment to do following: ... 1- chose a record from second database ... replace the Base record with the ...
    (microsoft.public.access.macros)
  • merging two .mdb files
    ... but the second database has a data subset of ... writing the SQL statment to do following: ... 1- chose a record from second database ... replace the Base record with the ...
    (microsoft.public.access.tablesdbdesign)