Transfer Text Import Specification not saving

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

I have a macro that imports a .txt file into a table
using an import specification. I went to run it today and
Access said that specification didn't exist, but when I
then imported using the File, Get External Data route, I
was able to choose that same specifiation and complete
the import. Can anyone tell me why it would be telling
me that it doesn't exist?
 
Mary said:
I have a macro that imports a .txt file into a table
using an import specification. I went to run it today and
Access said that specification didn't exist, but when I
then imported using the File, Get External Data route, I
was able to choose that same specifiation and complete
the import. Can anyone tell me why it would be telling
me that it doesn't exist?
Click to expand...

It certainly sounds very strange. Are you absolutely sure the import
spec isn't misspelled in the macro? Have you or anyone else modified
the macro or the spec recently?
 
Back
Top