I'm very sorry if this question has been asked elsewhere however I couldn't find it after a quick search...
My problem is that I am importing data from a text file into a table in my access (2007) database. I know how to run this in my database from the click of a button (DoCmd.RunSavedImportExport ("Import text files")) however I want to actually edit the name of the file being uploaded.
The user should be able to input the file path then this is used to import the respective text file onto a new table. I am unsure how to proceed and any method I have found so far is very complicated and involves accessing the XML file and changing the name directly. Is there any other way?
Thanks in advance