I have my export working. I used this code in a button:
Private Sub Command18_Click()
DoCmd.TransferText acExportDelim, "Material Export Specification", "MaterialExportFile", "L:\Interfaces\Import\Inv\Test Files\MaterialExportFile.txt", True
Is there a way to make it append the current date and time to the text file name (like: MaterialExportFile04162012_0814.txt or something like that.