Re: [MS_AccessPros] Merge Data of Two different databases

Thanks union works for me


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

> **
>
>
> Abdul-
>
> Why not just build a separate database with links to the four tables? You
> can use UNION queries to assemble all "customers" and related records for
> your reporting.
>
>
> 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 1:55 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: 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
>
>
>



--
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/