Output query as a text file?

[sabavno]

Looking for the code to output query as a text file.

 

[KyleS]

DoCmd.OutputTo acOutputQuery, "NameHere", acFormatTXT, "FileNameHere" Kyle

 

[sabavno]

Thanks

Just further on this issue
Can I control the format of output?
Say I need certain number of spaces between the columns in the text file

 

[KyleS]

Not with the "DoCmd.OutputTo" command. In order to do actual file manipulation you'll need to use the FileSystemObject (type that in code somewhere and hit F1 - there's way too much to go over here) Kyle

 

[mincefish]

Or try checking this thread out - this'll just write the results of a recordset out to a .csv file. You can adapt it to look at the fields and format certain ones.

thread701-337260

Good luck!

The Mincefish