The reason I am using variables for the name is they will eventually be dynamic, but Ineed to get the command correct first. It seems to start, but I get the error message:
"Field 'F1' does not exist in destination table 'Tax1'" There are no field names in the file (I believe that is the default argument, but even if I explicitly tell it there are now field names, I get this message. What am I doing wrong?
Is there a better method for doing this than using DoCmd.TransferText?
Last edited by cdols; 12-16-04 at 16:39.