exporting a query as a text file through vba

[Knobbie]

I have a situation where I need to export a query into a text file to match ASCII standards.

I have the query created and I have the code to loop through the query one row at a time and make the appropriate adjustments to each row (needing to add '|' and '~' delimiters for labels and data so it will be mapped correctly.)

the problem I have is that I'm sure of the code for creating the export as a text file (not MS Word). If you are familar with this export code can you help me out?

Thanks in advance for any help on this one I appreciate it.


-Knobbie

 

[Travis]

Look into the OPEN Function. This allows you to open and add text to a Text File.