exporting table through vb without strings having quotes

[Marshall Barton]

jmike wrote:

>anyone? easy to do manually, just having trouble finding
>vba that will allow this

Use the TransferText method.

One trick to using that is to first export some sample data
manually. As you work your way through the export process,
you will specify various options such as field deliminators,
quotes, etc, this stuff is collectively know as the
import/export Specification and can be saved with a name so
the process can be repeated easily. The specification name
can also be used with the TransferText method to duplicate
the actions you performed manually.

This is a fairly large topic so be sure to read Help for all
the details.

--
Marsh
MVP [MS Access]