VBA script to transfer results of query to fixed width text file

[nggman]

I have an Access query with many fields. I want to write a VBA script to transfer the results of the query to a fixed width text file. I do not need headers. I have all the specifications for the fields and their widths. I believe I need to start with the DoCmd.TransferText command and transferType:=acExportFixed but I am not positive. I just need a little push to get started. When I try just a simple transfer I get an error saying that I need a Specification Name argument.



DoCmd.TransferText transferType:=acExportFixed, TableName:="Name of my query", FileName:="C:\temp\TEST.txt"

[dashiellx]

Before you can do it in code, you'll need to do a manual export to create and save an Export Specification.

Right click on your query and select Export-->Text File



The "Save As" screen opens:

Click OK and the "Export Text Wizard" opens:


Click Advance and then set up everything you want:


Save your Specification and then you can do it in code:

DoCmd.TransferText acExportDelim, "Specification Name", "Query Name", strFileName

[nggman]

Thanks for the quick response!!