I'm about to quit!

[hipopony66]

I can take VB, but I HATE VB w/ SQL! I've been messing with this forever, and I have to have gotten EVERY possible error. What's wrong with it now? There's supposedly another error in the SQL statement. Someone help me before I give up on my program!

SQL = "INSERT into " & table & "(FilePath, Filename, Filesize, Artist, Title, Frequency, Bitrate, Length) VALUES ('" _
& Replace(strFilepath, "'", "''") & "','" _
& Replace(strFileName, "'", "''") & "','" _
& Replace(strFileSize, "'", "''") & "','" _
& Replace(strArtist, "'", "''") & "','" _
& Replace(strTitle, "'", "''") & "','" _
& Replace(strFrequency, "'", "''") & "','" _
& Replace(strBitrate, "'", "''") & "','" _
& Replace(strLength, "'", "''") & "')"
Cnn.Execute (SQL)