I have a some what strange request. I've done some digging on the forum already to find anything related to my issue but to no avail.
I'm running a technical metadata (TIFF Tags) check of files using ExifTool.
I use the command prompt to run me the list and export it as a txt or csv.
An example of this command line is:
So this example will give me the EXIF data of all TIF's found in the folder location and export it to the destination as a CSV.
Now I've been using Access in recent weeks to import this data into tables and compare them at various stages of capture and creation. For example, when the file is made the ExifTool is run. When the file(s) have undergone editing again the tool is run. And before it is ready to be completed it is run again. These metadata's are imported in Access for me to compare the data and see if there are any variances that are unusual or sign of errors. But doing this constantly has become very tedious and I've been wondering for some time now if I could simply run the Exiftool from Access itself and then import the list using VB into a table for comparison. But I have no idea where to start and there doesn't seem to be much info online regarding this issue.
The only ideas I've found so far is perhaps using Shell to run this? But that's pretty vague.
Anyone have any experience with something related to ExifTool or simply communicating with the command prompt in Access?
I'm running a technical metadata (TIFF Tags) check of files using ExifTool.
I use the command prompt to run me the list and export it as a txt or csv.
An example of this command line is:
exiftool -G4 -ext TIF -r -csv C:\Users\jamesg\Desktop\TIF > C:\Users\jamesg\Desktop\TIF\allmetadata-V01.csv
So this example will give me the EXIF data of all TIF's found in the folder location and export it to the destination as a CSV.
Now I've been using Access in recent weeks to import this data into tables and compare them at various stages of capture and creation. For example, when the file is made the ExifTool is run. When the file(s) have undergone editing again the tool is run. And before it is ready to be completed it is run again. These metadata's are imported in Access for me to compare the data and see if there are any variances that are unusual or sign of errors. But doing this constantly has become very tedious and I've been wondering for some time now if I could simply run the Exiftool from Access itself and then import the list using VB into a table for comparison. But I have no idea where to start and there doesn't seem to be much info online regarding this issue.
The only ideas I've found so far is perhaps using Shell to run this? But that's pretty vague.
Anyone have any experience with something related to ExifTool or simply communicating with the command prompt in Access?