Check composite PK on Access!

[RONMYKELLANG]

Good afternoon guys!

Here is the situation. I hope you can help me with this.

Im using Excel VBA as frontend and using Access as backend.
I am trying to import records from excel to access.
I have records with composite number of primary keys(3).
Is there a way to test if I am going to insert or update these records on the DB?
(programmatically at Excel VBA)

Main Problems
1. Is the look up of composite PK.

 

[noboffinme]

Hi RONMYKELLANG

I'm not sure what you're after, are you trying to see whether the records being transferred from Excel to Access are being appended to an Access table OR are overwritng any already exisiting data that would cause a duplicate?

If so, a copy of the db might help to look at.

If you went to transfer to Access & the data violated an Access Key restriction, the code will error of course.

Can you clarify what you want to do, Thanks