[RESOLVED] export data from msaccess to txt file....

[RobDog888]

You can use the .TransferText function in Access.

Application.DoCmd.TransferText acExportDelim, , "Table1", "C:\Test.txt", True