If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Merge data from one table into another table
Hi,
I have a table that contains customer details, including a unique CustId field. There is also another table with only two fields, CustId and CustRef. The CustRef is also a unique field required by a different department. I want to combine this data all into the main customer table and ditch the two field table. I have added a new field to the main table to accommodate the CustRef data but would like to merge this data automatically to save entering a few thousand records manually. Any ideas please. Example: Main Table: CustId CustRef Forename Surname 01397 Martin Jones CustRef currently empty as I have not transferred the data. Additional Table: CustId CustRef 01397 AR9723 How do I get the main table reading: CustId CustRef Forename Surname 01397 AR9723 Martin Jones Thanks John |
#2
|
|||
|
|||
Merge data from one table into another table
xpnovice wrote:
Hi, I have a table that contains customer details, including a unique CustId field. There is also another table with only two fields, CustId and CustRef. The CustRef is also a unique field required by a different department. I want to combine this data all into the main customer table and ditch the two field table. I have added a new field to the main table to accommodate the CustRef data but would like to merge this data automatically to save entering a few thousand records manually. Any ideas please. Example: Main Table: CustId CustRef Forename Surname 01397 Martin Jones CustRef currently empty as I have not transferred the data. Additional Table: CustId CustRef 01397 AR9723 How do I get the main table reading: CustId CustRef Forename Surname 01397 AR9723 Martin Jones Thanks John This is a job for an update query. -- Joseph E. Meehan 26 + 6 = 1 It's Irish Math |
#3
|
|||
|
|||
Merge data from one table into another table
Yes,
Ive just worked it out, I needed to ref the table/field names in the updata to: Thanks "Joseph Meehan" wrote in message ... xpnovice wrote: Hi, I have a table that contains customer details, including a unique CustId field. There is also another table with only two fields, CustId and CustRef. The CustRef is also a unique field required by a different department. I want to combine this data all into the main customer table and ditch the two field table. I have added a new field to the main table to accommodate the CustRef data but would like to merge this data automatically to save entering a few thousand records manually. Any ideas please. Example: Main Table: CustId CustRef Forename Surname 01397 Martin Jones CustRef currently empty as I have not transferred the data. Additional Table: CustId CustRef 01397 AR9723 How do I get the main table reading: CustId CustRef Forename Surname 01397 AR9723 Martin Jones Thanks John This is a job for an update query. -- Joseph E. Meehan 26 + 6 = 1 It's Irish Math |
Thread Tools | |
Display Modes | |
|
|