G
Guest
One tricky question
I have a two tables - one is a source data and the second one is a new data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes
For example
Record Table Heading
1 Source Department
1 New Department
I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?
I have a two tables - one is a source data and the second one is a new data.
The two have same column headings.
The new data table can have new records or same records same as source data,
but with some changes
For example
Record Table Heading
1 Source Department
1 New Department
I need to update the source data with the new records and update all the
information that has discrepancies in new data
I tried to set up a querry (miscrosoft querry) with no luck.
How to do it?