Export table Data

  • Thread starter Thread starter Sigh
  • Start date Start date
S

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.
 
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.
 
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.
 
Back
Top