OutputTo TXT file not same as Export - Fix?

[David Habercom]

When I OutputTo acFormatTXT from a one-field table, I get this:

----------------------
| Aaron |
----------------------
| Abbey |
----------------------
| Abbie |
----------------------
| Abbott |
----------------------
| Abdelhamid |
----------------------

When I Export to a text file, I get this:

Aaron
Abbey
Abbie
Abbott
Abdelhamid

Can I make OutputTo do the same thing as Export?

Thanks.

 

[Dirk Goldgar]

When I OutputTo acFormatTXT from a one-field table, I get this:

----------------------
----------------------

When I Export to a text file, I get this:

Aaron
Abbey
Abbie
Abbott
Abdelhamid

Can I make OutputTo do the same thing as Export?

Thanks.

I don't think so, but why not use TransferText instead?