Solved Append Query Key Violation

[JED25]

Here's your original query from your first post.

Here's the working query from @Eugene-LS from post #17.

They are not exactly the same. As far as I can see, the second/working query is missing two fields from your original query.

Yes I'm trying to randomize the data so I can just send everything.

 

[Eugene-LS]

working query is missing two fields from your original query.

Ye-e-e-e-e-s-s-s-s!
That's right.
But I worked with the file that was posted and there were really two fields missing.
I didn't make it up any more ...

 

[JED25]

Ok I randomized the data now.

 

[Eugene-LS]

Ok I randomized the data now.

Two fields were missing in the file: "MASTER DATA EXPORT TEST.xlsm"

 

[JED25]

Two fields were missing in the file: "MASTER DATA EXPORT TEST.xlsm"

Apologies, here is a copy that matches the DB

 

[Eugene-LS]

here is a copy that matches the DB

Some fields are perplexing ...

 

[JED25]

Some fields are perplexing ...

I've tried the date/time format, but I couldn't get it to ever transfer correctly from excel without having to retype it all because I did not create the original data. I have the calculated fields because I use them for other queries and reports.

 

[Eugene-LS]

here is a copy that matches the DB

That's why !

 

[Eugene-LS]

I've tried the date/time format, but I couldn't get it to ever transfer correctly from excel without having to retype it all because I did not create the original data.

There are some functions for data transform ...
TimeValue() for example ...

...
My local time is late, I'm tired.
I leave you in the good hands of the experts of this forum.
Good luck!

 

[JED25]

That's why !

Wow that was it!! Thank you so much!! Can you explain why that caused so much of a problem?

 

[Pat Hartman]

We don't know what you did to resolve the problem. Perhaps you could post the query that worked.

The target fields in the table were text so there should have been no problem appending string dates there. Using your original files, the query worked for me once I got rid of the two missing fields.

 

[Eugene-LS]

Can you explain why that caused so much of a problem?

Before adding new records to table "INTAKELOG" you should have "Relation key ID" record in table "CLIENTS" for each new record.
...
And read: Introduction to data types and field properties - that's about second screenshot from post #28 ...

 

[JED25]

We don't know what you did to resolve the problem. Perhaps you could post the query that worked.

The target fields in the table were text so there should have been no problem appending string dates there. Using your original files, the query worked for me once I got rid of the two missing fields.

The query wasn't the problem. I had a relationship between my client IDs and they were set to double instead of long integer. Once I changed that in my original DB everything appended correctly.

 

[Pat Hartman]

Thanks for the update