Upon import of a .txt file into an temporary access table, I recently have started to encountered an error. Whenever I run the saved import I receive these two message boxes.
I have checked to make sure that the file that I am importing has unique data, and is in the same format as the initial file used to set up the import, and it is.
It is really odd because after I receive these messages, you would think that it would end the import, but instead it completes the import and the table appears with no issues, and no missing data. This would not be such a big deal if it did not throw an error with the macro that I have set up. Has anyone ever encountered an issue like this?