MS Access Database with External Data - Export to text file with no text qualifier

Author

Export to text file with no text qualifier

Cindy

2005-09-19, 9:24 am

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?

Ken Snell [MVP]

2005-09-19, 11:24 am

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.

--

Ken Snell
<MS ACCESS MVP>

"Cindy" <Cindy@discussions.microsoft.com> wrote in message
news:63D3CC8B-A582-4844-B110- 8F5BED551644@microso
ft.com...
> 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?

Sponsored Links