Hi all. I want to be able to run ExifTool through MS Access 2019, create a CSV and then import that CSV to a table in Access. Now I actually figured out how to do this by simply running a .bat file with the EXIF command in it. And then in VBA tell it to run the .bat file, wait for it to create the CSV and then import into a table in Access.
But I am trying to see if I can tell which folder I want to run ExifTool by browsing to that folder (using Application.FileDialog(PickType) in VBA) instead of specifying it in the EXIF command itself. I know how to create a browse function in Access. But I don't know how to tell ExifTool to run the command from that location. I want to do this so I don't have to specify a location in the EXIF command each time I want to run from a different location. Simply browsing to that folder and running it would be my aim.
Anyone tried this or has any ideas?
You might have better luck asking this in an MS Access forum.
- Phil
Sure. Thanks Phil.