Export to an text-file using VBA

[Gunilla]

I have a table with 15 columns. I want to export it to a text-file and place it in a folder in My Documents. Is there a way to do that with VBA.
I am using Access2003.

 

[pbaldy]

Look at TransferText in VBA help.

 

[Gunilla]

I have done that, but it does not print the textfile.

DoCmd.TransferText acExportFixed, "ExportToMSIS", "ExportToMSIS", OutputFile

Where "ExportToMSIS" is both the SpecificationName and the TableName.
What am I missing?

 

[pbaldy]

You said you wanted to export the data and put it in My Documents. Is that code not doing that? If you want to print the data, just print a report based on the data.