Export to text file with no text qualifier

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cindy - 19 Sep 2005 14:51 GMT

How do I export data to a text file using the transfertext command and having
the data be comma delimited with no quotes?

I can export comma delimited with and without quotes using the Export
wizard. How could I automate these two exports? Are there other methods?

Reply to this Message

Ken Snell [MVP] - 19 Sep 2005 15:36 GMT

Use the TransferText method (macro or VBA code) to do the export. You can
then use an export specification (which you create by manually doing the
export once and saving the settings to a specification name) to format the
output as you desire.

Signature

Ken Snell
<MS ACCESS MVP>

> How do I export data to a text file using the transfertext command and
> having
> the data be comma delimited with no quotes?
>
> I can export comma delimited with and without quotes using the Export
> wizard. How could I automate these two exports? Are there other methods?

Reply to this Message