the statement is :

sqlstat = "INSERT INTO Appels (numero, a_comp, a_qui)"
sqlstat = sqlstat & " VALUES (' "& int(exp_count)+1 &" ',,' "&comp_a&" ','
"&qui_a&" ');"

using the method writeline, I want to write this SQl statement in a text
file that will be in fact an .ASP file.
How to deal with the quotes while the writeline method also use double
quotes
ObjFile.writeline " text to be written "

I get very confused with that and would appreciate if someone could help me
to solve this problem.

dim q as string
q=chr(34)  'double quote

 sqlstat = "INSERT INTO Appels (numero, a_comp, a_qui)"
 sqlstat = sqlstat & " VALUES (" & q & int(exp_count)+1 &  ",, " & comp_a &
" , " & qui_a & q & " );"

I'm not sure of the actual syntax, but that may work.

steve