code for saving a table into a text file.

[Guest]

Can someone show me how to write the code to save a table into a text file?

Thanks!

 

[Guest]

Thanks Allen!

Try TransferText.

Example:
DoCmd.TransferText acExportDelim,, "Table1", "C:\Table1.txt", True