Formatting problem, help!!!

[Serge]

Hi people!

need your help to fix this. I output the query resutls to
a text file and here is the part of the code

Dim strFixedIP As String

strFixedIP = "qryFixed_IP"
DoCmd.OutputTo acOutputQuery, strFixedIP,
acFormatTXT, "C:/temp/list.txt"

the result looks this:
----------------------
| Fixed_ip |
----------------------
| 0,10.88.32.1 |
----------------------
| 0,10.88.32.1 |
----------------------
| 0,10.88.32.30 |
----------------------
| 0,10.88.32.31 |
----------------------

Could you help me to get results without column headings
and no formatting, so it will look like this:

0,10.88.32.1
0,10.88.32.1
0,10.88.32.1

Thanks a lot!

Sergei

 

[Ken Snell]

Use DoCmd.TransferText method instead of DoCmd.OutputTo