Using strings in SQL statement.....

[hipopony66]

Hey, I resolved my adding records problem, but I need to fix this last error. Rikk gave me a tip on how to do this, but I keep getting the error. It has to do with the strings containing the '.
I changed the SQL to REPLACE the ' with ''. Here's what I've got:

SQL = "INSERT into " & table & " VALUES ('" & Replace(strFilepath, "'", "''") & "','" & Replace(strFileName, "'", "''") & "','" & Replace(strFileSize, "'", "''") & "','" & Replace(strArtist, "'", "''") & "','" & strTitle & "','" & Replace(strAlbum, "'", "''") & "','" & Replace(strFrequency, "'", "''") & "','" & Replace(strBitrate, "'", "''") & "','" & Replace(strLength, "'", "''") & "','" & Replace(strTrack, "'", "''") & "')"
Cnn.Execute (SQL)