I have an access database where I insert some records into my table. The records are file names from certain folders. The query works fine (please see the code below).
The only issue is when a file name has an apostrophe in it. For example a file called "Word Documents" would work fine, however a file called "Word Document's" would not work becuase of the apostrophe.
Any help would be great.
strSQL = "INSERT INTO tblCompanyFiles ([Ticker], [Folder], [FileName], [DocType]) " & _
"VALUES ('" & Ticker & "','" & objFolder.Name & "','" & objFile.Name & "','" & DocType & "');"