Re: [MS_AccessPros] Merge Data of Two different databases

Dear John

Thanks for your valued help, you asked me for any duplicate value I've very
unique IDs for customers in both the database so I think there would be no
conflict of any such kind, however from your answer it looks like that all
the tables in new database will be update only once, however I want to sync
this new database with DB1 and DB 2 for real time changes, because I ll use
it only for reporting purpose


On Tue, Jul 2, 2013 at 4:09 PM, John Viescas <JohnV@msn.com> wrote:

> **
>
>
> Abdul-
>
> In a new database, click on External Data / Access and then link the two
> tables in the first database. Link the two tables from the second database
> in the same way. The easy way to build two new tables is to select one of
> the linked tables, copy it to the clipboard, then Paste Structure Only. Do
> that for each of the two different tables.
>
> Now comes the hard part. You can certainly build two Append queries using
> the linked tables from the first database to dump the data into the new
> tables you just built. If there are no conflicts of Primary Key values, you
> can do the same with the other two linked tables - ending up with two
> merged
> tables. But if you have, for example, a row in each of the two tblCustomer
> linked tables that both have the same value, you'll have to massage the
> data
> to get a proper merge.
>
> Let me know if you have any duplicate values, and I'll try to guide you
> from
> there. I will need to know the data types of the Primary Keys and any
> Foreign Keys in both sets of tables.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul
> Shakeel
> Sent: Tuesday, July 02, 2013 12:24 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Merge Data of Two different databases
>
> I have two different databases with same tables but different set of data
> in
> both tables how do I make a new database merged data of both the database
> tables. lets say in DB 1 I have tblCustomers and DB 2 tblCustomer how do I
> link data of these two tables in DB 3 tblCustomers
>
> --
> Regards,
> Abdul Shakeel
>
> [Non-text portions of this message have been removed]
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>



--
Regards,
Abdul Shakeel


[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/