bhelmy: I have not addressed you post directly ,but would not the following achieve the result you require ?
I placed the following into another command button and it worked.
#DoCmd.TransferText acExportDelim, test, "Table1", "c:\mydocuments\StartNet1.txt", _
HasfieldNames:=True#
Regards Ypma