It was simply an example. A #DEFINE could be numeric. You have to find out the value of acEXPORTDELIM. It will probably be listed somewhere in Access help or you could use the VFP Object Browser to find it.
>Hi Craig,
>
>Thank you for your the help.
>
>However, in your example MyConstant contains the TEXT value "Eat at Joe's".
>The Access method will not accept a text value. It is expecting one of it's constants or flags like acEXPORTDELIM.
>
>Notice the Access Help example:
>DoCmd.TransferText acExportDelim, "Standard Output", _
> "External Report", "C:\Txtfiles\April.doc"
>
>I'm perplexed,
>Gaylen Miler
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer