Export a Query To .txt File

[Guest]

Hello..

I have a query called stage2. I would like vbcode to open this query and
then export the data to a file called stage.txt (comma delimeted format) off
the root of C:\.

Thanks for your help.

 

[Ken Snell [MVP]]

See TransferText in Help file.

 

[Douglas J. Steele]

Take a look at the TransferText method in the Help file.