Importing data into two tables

  • Thread starter Thread starter commassociates
  • Start date Start date
C

commassociates

I have two tables. Table 1 will be Orders and Table 2 will be
Customers. Here are the fields:

Customers:
Customer Name
Accout Number
etc.

Orders:
Order Number
Amount
Account Number
etc.


I will be importing data from excel with all the orders. What i want
to be able to do is when i import orders into the "Order" table, and
there is a new account number that is not in "Customers" table, i want
it to add a new record in the Customer's Table with that account
number. Is this possible?
 
I have two tables. Table 1 will be Orders and Table 2 will be
Customers. Here are the fields:

Customers:
Customer Name
Accout Number
etc.

Orders:
Order Number
Amount
Account Number
etc.

I will be importing data from excel with all the orders. What i want
to be able to do is when i import orders into the "Order" table, and
there is a new account number that is not in "Customers" table, i want
it to add a new record in the Customer's Table with that account
number. Is this possible?
Click to expand...

Import the new Customers first by using an outer join and turning it
into an append query (use the find unmatched query wizard). Then you
can just import all the other data into the Orders table... (Well,
assuming, probably incorrectly, that it's normalized.)
 
Back
Top