zelarra821
Registered User.
- Local time
- Today, 23:00
- Joined
- Jan 14, 2019
- Messages
- 813
Buenas tardes.
I have two tables, in which I save the names of files that I have in a folder on my computer.
In one of the tables (Table1), I save the name that I get when traversing the folders using VBA.
And in the other table (Table2), I keep a manual record because each file I record it in a series of categories that would be difficult to do using VBA.
So, what I need is to obtain the names that are in Table2 but that no longer exist in the computer, that is, they would not appear, therefore, in Table1. And, on the other hand, the names of Table1 that are not yet registered in Table2.
Both names are not related by ID.
Nor have I been able to do it by query: first a union query of both tables, and then a select distinct, because obviously it shows me a relationship of unique records, and that's not what I want.
Let's see, right now I'm doing it through VBA, going through the files in the folder, but since there are many, it takes me a long time to perform the verification, and I wanted to know if it was possible to do it through the tables, or queries, with something else simple and fast, because the information is already in the tables.
Thanks!
I have two tables, in which I save the names of files that I have in a folder on my computer.
In one of the tables (Table1), I save the name that I get when traversing the folders using VBA.
And in the other table (Table2), I keep a manual record because each file I record it in a series of categories that would be difficult to do using VBA.
So, what I need is to obtain the names that are in Table2 but that no longer exist in the computer, that is, they would not appear, therefore, in Table1. And, on the other hand, the names of Table1 that are not yet registered in Table2.
Both names are not related by ID.
Nor have I been able to do it by query: first a union query of both tables, and then a select distinct, because obviously it shows me a relationship of unique records, and that's not what I want.
Let's see, right now I'm doing it through VBA, going through the files in the folder, but since there are many, it takes me a long time to perform the verification, and I wanted to know if it was possible to do it through the tables, or queries, with something else simple and fast, because the information is already in the tables.
Thanks!