I have a excel file, a.xlsx that I successfully external data append to a table. I save the import as import1
In a form the user can select the same file with a different name, I rename it to be the same file name the saved import is looking for, then I execute vba to run the import1 saved import,
DoCmd.RunSavedImportExport ("import1") but get the 3709 error.
so it works when importing the first time to save the import, but errors when I run the
import via vba. I can run the external data import manually a second time with no error.
nothing I google explain why this would be occurring in my case