Export table Data

[Sigh]

Hi,
Right now I am export the Data from my table to the
Text File with no delimiter manually. But I would like to
created the command button and write the code to Export my
table data to Text files. In this I will save alot of time.
What is the code that I can write to perform this function?

Any help would be very appriceated.

 

[Ken Snell]

Private Sub cmdButtonName_Click()
DoCmd.TransferText
End If

Note that there are various arguments that are mandatory and some that are
optional for this TransferText command.

 

[Joe Fallon]

Build a specification first.
Export it manually and step through the wizard.
Before you hit Finish, click Advanced and save the spec.
The use TransferText and the spec.