Question
Handling apostrophes
I have an excel spreadsheet that I have to upload into our
database. Some of the fields have apostrophes in them such as the
last name O'Brien.
When I try to store that into the database, I get an error since I have to use '#last_name#' in my query.
Is there a way to handle this?
When I try to store that into the database, I get an error since I have to use '#last_name#' in my query.
Is there a way to handle this?
AdChoices