prevent quotes around string in a text file 1

[smcmanus]

I am writing sql statments in VB and dumping them into a text file but the string has quotes around it. e.g.
"INSERT INTO tblPayroll(fldAmount) VALUES(pstrAmount)"
I want to be able to get rid of this quotes on the end. When I run my SQL script it does not work.

 

[jmarler]

rather than using VB's write command, use the Print #intFilehandle command. For example . . .

Dim intFileHandle As Integer
Dim strSQL As String

strSQL = "Select * from Somewhere"
intFileHandle = FreeFile

Open "C:\TestData.Sql" For Append As #intFileHandle
Print #intFileHandle, strSQL
Close #intFileHandle

- Jeff Marler B-)