I use docmd.Transfertext to import a CSV with a specification name to a table in ACCESS. I use DAO setting. There are times when I get an error message saying that the "command or action Transfertext isn't available now". Sometimes it works correctly and other times, it doesn't work.
This is the syntax I use -> DoCmd.TransferText acImportDelim, specs, tablename, sourcefile, True

I don't understand why it's giving me this error. I google but couldn't find any reference to my problem.

I am so frustrated. Any help would be greatly appreciated.