delimiter problem

[Tom]

Using Access 2002, I wish to export a table as a csv file.
If I manually config an Export Specification to use ^ as
the field delimiter everything exports OK.

If however I use
DoCmd.TransferText acExportFixed, "Property Export
Specification", "Property", "C:\Temp\test.csv", True
the delimiter reverts back to a comma.

Any advice on why this happens and how to overcome it
would be appreciated.

Thanks in advance

Tom

 

[TOm]

Found my problem - should have used acExportdelim not
acExportFixed - and all is OK