I am importing data into an sql table ("temp") from a downloaded .csv file.
There are a few records containing an apostrophe e.g.
Code: Select all
PILGRIM'S PRIDE LT NO REF BGC
Code: Select all
hConn.Find("temp", "sMemo = '" & Replace(sVar, "'", "''") & "'")