It can be done. I have used imports from a text file, using CSV format, importing into Access using an import query
you can automate it using a script created in DOS running in the windows scheduler calling Access and the autoexec macro. It may be appropriate to run the access import function as a separate MDB.
If your file reference is embedded then you may need todo it as a VB function as it may be difficult to run the query with a parameter. Alternatively you could always use a vb function to append a query to the quesries collection in the revised format.