ADP CSV export

[Wisely]

Hi,

I'm using ADP to export a CSV file with delmited "!" from a SQL table by
using docmd.transfertext acexportdelim,,"dbo.tablename", "destination file
path", True the delimited is default to "," (comma). And ADP cannot set up
the specificationname where I want to set up the "!" delimited.

any one know how to do this?

thanks,

Wisely