I have the following code that works fine on MS Access 2002.
DoCmd.TransferText acExportDelim, , "ZSTALEO_TBL", "c:\ZSTALEO.txt", False
However in Access 2003 it does not and it gives Runtime error 3441, "Text file specification field separator matches decimal separator or text delimiter"
Any suggestions why this does not work in Access 2003? Note that the forms data in 2003 are in SQL, if this makes a difference.
DoCmd.TransferText acExportDelim, , "ZSTALEO_TBL", "c:\ZSTALEO.txt", False
However in Access 2003 it does not and it gives Runtime error 3441, "Text file specification field separator matches decimal separator or text delimiter"
Any suggestions why this does not work in Access 2003? Note that the forms data in 2003 are in SQL, if this makes a difference.