My Access application uses a button to execute a "Saved Import" that updates a table. After the text file has been imported, I need to delete it from its location on the C drive. (C:\programdirectory\transactionlog.txt) I'd prefer to use a Macro to accomplish this, but there doesn't appear to be a proper function available. I'm not familiar with VB so if code is needed to do this, can someone help?
(I'm migrating the application from different programming software and could previously "evaluate" an IODEL function and provide the path to the file. It was very simple and effective but Access doesn't appear to utilize this function. )