Asp page derived data, but just want to check out part of the field, should do
If not rstData. Eof and not rstData. Bof then
StrLine=""
StrLine="header information" & amp; CRH (9) & amp; "In column" & amp; CRH (9) & amp; "The author" & amp; CRH (9) & amp; "To submit the unit" & amp; CRH (9) & amp;" The release date "& amp; CRH (9)
Myfile. Writeline strLine
The do while not rstData. Eof
StrLine=""
For each x in rstData. Fields
StrLine=strLine & amp; X.v alue & amp; CRH (9)//this part doesn't want to check out all the fields, just want to pick a few fields, guide to excel file
Next
Myfile. Writeline strLine
RstData. MoveNext
Loop
End the if

CodePudding user response:

I use is relatively rigid methods: rstData (I). The value, if there is a good method, hope everyone to share

CodePudding user response:

reference 1st floor JessieZao response:

I use is relatively rigid methods: rstData (I). The value, if there is a good method, I hope you share

The start when the select. Just choose you to be exported.
Rather than select *. Finally to pick

CodePudding user response:

Upstairs is
The SELECT field, A field, B... Z, field FROM the table