Using VBA – DoCmd.transfertext, the file name (ex. “C:\My Documents\Oops\transfer.txt” will bomb out.Even if I use “C:\’My Documents’\…”. it gives the same error. It definitely is the space that is causing the problem. I have separated the path and combined it programmatically, but the same results. I am using OFF XP and Win XP professional. My_Documents is not a viable solution. I’ve tried “”””…”””” and other combo’s that have worked in the past in other areas, but this is the first problem I’ve encountered in transfertext of this sort.