I am setting up a Picture/Video DBS in MS Access 365, (a "one place to go and view")to enable me to track all the personal Photos and videos stored on any hard drive, cloud.....etc etc.
I have completed the forms/Code for logging the Photo and Video "Paths" in the database using a batch import, and can view the latter. Tks for your tech help videos on how to store images in a Access DBS. Now I need to import the Meta data or properties of these Photos/Videos as it is stored in windows 10. "Right Click" on the images from the MS access form is a no go to get to this info. It will be an almost impossible task logging the Meta data manually!.
I have searched on the web and found some elaborate Code. Yes I think i might have to call some API or something. Logging the Meta data in the DBS is no problem for me, but, identifying/extracting the meta data is the real headache as it needs to be a batch proses.
Can u assist.
Tks.
Kevin Yip
@Reply 2 years ago
I would use a third-party tool like Exiftool ( https://exiftool.org/ ) to export the meta data to a text file, which can be imported into Access. Exiftool supports command-line options, which Access can use with the Shell() function in VBA. The command line returns neat columnar data (see picture below) that Access can easily import from.
Kevin Yip
@Reply 2 years ago
Kevin Yip
@Reply 2 years ago
As a side note, different files types have different types of meta data. MP3 music files have "tags." Different camera models put different meta data into photos. The third-party tool you use has to be able to support them, so read the documentation that comes with it.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
