hi

i make a code to read string from txt file and store it in string i call it (totsun). i want to insert values in a table withe two columes (oracle database) and the string totsun i want it to consider as the table name. the values to be inseert is y and ttime.

i want to write it as
strSQL = "insert into totsun values('y','stime')"
but i can't write " as a string

here my code


Open "C:\s1.txt" For Input As #2
Print ""

linecount = 1
Do While Not EOF(2)


string1 = "insert into "
string2 = "values('" & Chr(34) & " y " & Chr(34) & "','" & Chr(34) & " stime" & Chr(34) & "')"



Line Input #2, totsun
linecount = linecount + 1
Loop
Close #2
On Error GoTo ErrMsg

y = y & " , "
ttime = Format(Now, "HHMMss")

strSQL = Chr(34) & string1 & totsun & string2


could you plz check it and help me


i try to writ " as Chr(34)