Posted by Plamen Ratchev on 01/24/07 02:07

Hi,

If I understand correctly you want to eliminate the first row in the result
text file which contains the field names. In your code you have a loop that
writes those to the text file:

> For i = 1 To oRSc.Fields.Count
> objTextFile.Write oRSc.Fields(i-1).Name
> If i < oRSc.Fields.Count Then
> objTextFile.Write " "
> End If
> Next
> objTextFile.WriteLine

Just comment out the section above and it should no longer write the field
names to the output file.

Regards,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]