spacepro
Registered User.
- Local time
- Today, 17:31
- Joined
- Jan 13, 2003
- Messages
- 715
Hi Guys,
Done a search of the forum on this, but some of the answers have not been concise or don't apply to my situation.
Anyway, I want to import data into the db but how do I import into multiple related tables.
FOr example:
tblCustomer
CustID
CustName
CustAddress
tblOrders
OrderID
CustID
OrderNo
tblOrderDetails
OrderDetailsID
OrderID
Product
ProductQty
How do I import the data from excel into access into the above tables? Do I import into a temp table then transfer data to the individual tables - how would I relate the data and keeping RI rules intact.
I would like to do this through code, but need an overview from someone on how to accommplish this.
Many Thanks
Andy
Done a search of the forum on this, but some of the answers have not been concise or don't apply to my situation.
Anyway, I want to import data into the db but how do I import into multiple related tables.
FOr example:
tblCustomer
CustID
CustName
CustAddress
tblOrders
OrderID
CustID
OrderNo
tblOrderDetails
OrderDetailsID
OrderID
Product
ProductQty
How do I import the data from excel into access into the above tables? Do I import into a temp table then transfer data to the individual tables - how would I relate the data and keeping RI rules intact.
I would like to do this through code, but need an overview from someone on how to accommplish this.
Many Thanks
Andy