Transfer Text Import Specification not saving

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?
 
D

Dirk Goldgar

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Can't save my Office documents (after computer rebuild and reauthorization) 0
Modifying an import specification 0
Text Import Specification Missing 3
Synchronization problems while moving folders to new email 1
Importing Text Files 2
Extracting date file modified from a text file. 4
Import File / First Line Has Date Info 0

Top