I have been looking around for a while and I was not able to find something similar related to this question. I’m trying to develop a macro in excel and use MS access to storage data. What I’m trying to do is the following:
-
With the macro interface, the user selects a spreadsheet with the information (PN, description, price, etc.) using “GetOpenFilename”
-
I have my table in MS access called “Material”. To avoid any duplicate PN. First I want to validate that the PN listed in the spreadsheet is not already in my database.
I have been trying using Dcount and OpenResordser but I always get a true value even when I have same PN in access table.