Data not transferring

[Ron Wilson]

Hi, I'm running 2 append queries to my existing db to update fields in one table with data from 2 sources - basically plucking some fields from one and some from the other (using a client ID number as the common identifier - the data is fed into the parent table). However, it would appear that some of the data is not transferring into the parent table even though it is visible in the source file (.xls). I know that this seems like a broad request but I'm just wondering if there may be a potential simple error. Any ideas?

Cheers....

 

[MStef]

Hello Ron!

What do you actually want ??? To APPEND or to UPDATE.
It must be you made a mistake somewhere.

 

[gemma-the-husky]

if you DONT turn off warning messages, the query will tell you why it cant add certain records

duplicates, invalid keys etc ...