To import a csv file I have written code:
DoCmd.TransferText acImportDelim, "99RN", "T_CYC", RNpath & "" & RNfile, True, ""
I get a message "Error 3625 99RN doesn't exist etc."
I go back, redo the import manually and try to name it 99RN and get a message that I can't name it 99RN as that spec name already exists.
Any ideas? Driving me nuts.