VBA Code to run a query and then export the query as a fixed width .txt file

[Keevo]

Hi All



basically im trying to setup a click button that will export my query as a text file ( the text file will then be fixed width and i have already setup the specifications for this)

i think i get how to complete the export part as below

OutFilePath = "file location i want the data to be exported to"

DoCmd.TransferText acExportFixed, "Welcome output query Export Specification", WelcomeOutput, OutFilePath, True

i just dont know how to run the query and link it to the export

Hope this makes sense and thanks in advance for any support provided.

[June7]

The query doesn't have to 'run'. Just execute the TransferText command.

[Keevo]

Takes a special kinda stupid to have the working code and not test it haha !!!

i presumed it would be more complicated that it was

thanks for your help