I am running Windows 8.1 and Access 2013. I have an Access 2013 database into which I am constantly importing text files. The procedure for importing the text file is exactly the same in every case except for the name and location of the text file and the table into which the file would be imported. I would like to save/run the steps of the import until it comes to the point where the user would need to enter the name/location of the text file and the name of the table into which the text file would be imported.
When I do this manually, Access asks me if I want to save the import, but the saved import of course includes the actual file name and the same table, which I need to change every time I run it. I can't find any way in Access to edit the import steps to allow for user input. Can somebody tell me if this exists in Access 2013?
Thanks.