How to combibe data from different databases?

  • Thread starter Thread starter GZ
  • Start date Start date
G

GZ

Hi, there: I created one Access database and copied the database to
different computers. Now, I need merger these data to one. How can I do
this? One big problem is there are some keys may be duplicated such as auto
numbered field. How can I deal with this problem?
Thanks!
GZ
 
Thanks for your reply!
I find some very useful information. I am interested in the following query:
--------------------------------
INSERT INTO Orders ( CustomerID, EmployeeID, OrderDate )
SELECT Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate
FROM Orders IN 'C:\program files\Microsoft Office\\Samples\Northwind.mdb';
-----------------
However, I have no idea how to conditionally append a table to another.
Let's say, if the inserted CustomerID is the key, but there are duplicated
CustomerID, what I need is: if duplicated is found, then make some
modification on the CustomerID before it is inserted to the table. How can I
do this?

Thanks!

GZ
 
Back
Top