I am working with a linked sql table which I was able to set-up up thanks the help of you guy's here on this board.
the code below (thanx to Ahnold) is used to create the SQL statement which enables me to enter the values in my SQL table.
Basically I read a "files and folders" listing into a sql table
the problem starts when a file or folder name contains a single quote and ofcourse this can be anywhere in the string.
Any suggestions how to deal with this?
the code below (thanx to Ahnold) is used to create the SQL statement which enables me to enter the values in my SQL table.
SQL = "INSERT INTO tblFoldersandFiles (map, datum, grootte, bestandsnaam)" & _
"VALUES ('" & strMap & "','" & strDatum & "','" & dblGrootte & _
"','" & strBestandsnaam & "')"
Basically I read a "files and folders" listing into a sql table
the problem starts when a file or folder name contains a single quote and ofcourse this can be anywhere in the string.
Any suggestions how to deal with this?