Selasa, 02 Juli 2013

RE: [MS_AccessPros] Merge Data of Two different databases

 

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

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)
.

__,_._,___

Tidak ada komentar:

Posting Komentar