TransferText command

[Guest]

Hi!

I'm using DoCmd.TransferText to save a table to a text file.

Here's my table:
a,apple,alpha
b,ball,beta
c,cat,gamma

However, the resulting text file inserts quotations around each table entry,
like this:
"a","apple","alpha"
"b","ball","beta"
"c","cat","gamma"


How do I avoid the quotation marks?

Thanks.
Ron

 

[Ken Snell [MVP]]

You also need to use an export specification for the export. The
specification will tell ACCESS not to treat the result as a string, but
instead as a date.

You can set up an export specification by doing the export manually -- and
then, on the last screen of the wizard window, click the Advanced button at
bottom left of the screen. A screen will display that allows you to set the
data type, etc. of the individual fields. You then can save that
specification with any name you wish. You then can cancel the export that
you'd begun.

Then use this export specification name as the "Specification" argument of
the TransferText action.