Hi guys,
I’m having trouble with append queries. I have the following tables:
Customer Number
First name
Surname
DOB
Post-code
A company will occasionally send us large updates to post-codes which will show records and new data. It’s not as simple as replacing the entire file, they will only send us a few amendments and not the entire database I need to append this data into the existing table so for example I have
Customer Number: 123
First name: Bob
Surname: Smith
DOB: 21-01-2001
Post-code: MK408EE
The company would send me through
Customer Number: 123
First name: Bob
Surname: Smith
DOB: 21-01-2001
Post-code: MK402LL
I am having no luck appending this as my query seems to simply over-write all of the data in the post-code table leaving blanks– how can I get the database to look at the customer number and appropriate, change the post-code - can anyone suggest proper structure?
Thanks in advance
I’m having trouble with append queries. I have the following tables:
Customer Number
First name
Surname
DOB
Post-code
A company will occasionally send us large updates to post-codes which will show records and new data. It’s not as simple as replacing the entire file, they will only send us a few amendments and not the entire database I need to append this data into the existing table so for example I have
Customer Number: 123
First name: Bob
Surname: Smith
DOB: 21-01-2001
Post-code: MK408EE
The company would send me through
Customer Number: 123
First name: Bob
Surname: Smith
DOB: 21-01-2001
Post-code: MK402LL
I am having no luck appending this as my query seems to simply over-write all of the data in the post-code table leaving blanks– how can I get the database to look at the customer number and appropriate, change the post-code - can anyone suggest proper structure?
Thanks in advance