Just an update, I looked back at Isaac's idea on running a .bat file to do this and it works a lot better than trying to run exiftool with Shell.
All I did was use wsh to help me for the Wait.
'code to run the bat file here
wsh.Run(strCommand, _
WindowStyle:=0, _...
Okay, it seems like Access needs to wait for the file to be created first before it can import. Because when I run the sub now, it gives me the same error. But when I end the process and find the CSV in the specified location and re-run the sub, the data successfully imports into the table. So...
Okay I've looked into why it wasn't working. When I do the import wizard, I have set the options as so:
Then when I finish the wizard, it successfully imports the data into the table.
Does this mean anything significant to you, at least when coding it? Like default for TransferText is...
That was good catch @theDBguy because when I ran the wizard it said some records (from the CSV) weren't able to append into the table. Now that's a bit of a dilemma. When I open my new CSV manually and save it as .xlsx, then try importing that new excel, then everything imports fine. So now I'm...
Hi Vlad,
To be honest I wasn't sure how to fill the rest of the arguments to the TransferText method 😂 I know that I can skip HTMLTableName because I was doing an acImportDelim but with SpecificationName and CodePage Identifiers I am proper lost!
Will leaving this out effect the import?
Yep so the command worked. The CSV file was created. I checked in the specified folder location and it was successful. But then when it tries to do the TransferText part it gives me the error I mentioned above in my previous post. I did it like this:
DoCmd.TransferText , , "tblData"...
Just to update you @theDBguy
I've got the command line working and creating a CSV.
RunExif = Shell("cmd /k exiftool -G4 -ext TIF -r -csv C:\Users\jamesg\Desktop\TIF > C:\Users\jamesg\Desktop\TIF\allmetadata-V01.csv
Forgot to add the "cmd /k". Now that I've got that step going, just not...
Hi. So when I run the sub, the ExifTool opens. It starts processing some command lines. After running it closes. And then that's it. It doesn't create a CSV or import into the table.
The command prompt is supposed to invoke ExifTool with the command I input, which is:
exiftool -G4 -ext TIF -r...
Thankyou for all the replies. I've done some research into all the responses. As @bastanu says, I want to run the exiftool to create the .csv and then import into table.
But Vlad is there a way to use the command prompt to run my command line like in OP?
exiftool -G4 -ext TIF -r -csv...
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...
Hello all. My name is James. I'm a business graduate and have been learning code on the side. I'm new to Access so I will definetly be asking a lot of questions from the pros! Hopefully I will learn as I ask more. Thankyou.