Have been using the saved imports in access to import excel data into access tables. Like the way it works except for the difficulty when you have to move the program from one directory to another, means have to redo all of the saved imports to reference the new location. Very time consuming.
Is there VBA code that will perform the same action as the access saved imports? That way, just have to change the location in the code instead of redoing the saved import.