Thanks Paul!
Oh God it was so obvious!! :banghead::banghead::banghead:
I guess I just got too focus on how to use the filepath that I was given, when I could simply just have done this from the very beginning and make the call only to open access...
many thanks again and have a great weekend :)
Hi everyone,
I wonder if you could help me. We receive a daily csv file from another database and we are trying to automate this process as much as possible.
At the moment, the other system will extract any new records, save a file as importddmmyyyy.csv in a specified location e.g...