Formatting problem, help!!!

  • Thread starter Thread starter Serge
  • Start date Start date
S

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
 
Back
Top