Hi all. I have a database that retrieves the metadata properties of a file:
Path, Name, Size, Owner, Date Created, Date Last Modified, Date Last Accessed, Type.
Now I'll be getting people to run imports on a directory every morning. The idea of that is to:
1) Import new files into the database
2) Track the changes to the existing columns
Now my issue is I'm not able to figure out how to do point 2. Because I don't want to import files that are already existing in the database. So I added check for if that file exists then don't import. But in order to track changes made to files since last import, I probably need to import them right? So what should I try doing here? I want something like, 'if file exists then skip, except if date last modified has changed'. But I don't know VBA well enough to make it do this for me. Or perhaps this isn't a VBA thing? Not sure.
I've attached a sample of my database. Thanks.
Path, Name, Size, Owner, Date Created, Date Last Modified, Date Last Accessed, Type.
Now I'll be getting people to run imports on a directory every morning. The idea of that is to:
1) Import new files into the database
2) Track the changes to the existing columns
Now my issue is I'm not able to figure out how to do point 2. Because I don't want to import files that are already existing in the database. So I added check for if that file exists then don't import. But in order to track changes made to files since last import, I probably need to import them right? So what should I try doing here? I want something like, 'if file exists then skip, except if date last modified has changed'. But I don't know VBA well enough to make it do this for me. Or perhaps this isn't a VBA thing? Not sure.
I've attached a sample of my database. Thanks.