delimiter problem

  • Thread starter Thread starter Tom
  • Start date Start date
T

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
 
Back
Top