[sql] - Single Quote in SQL Query

programming
1

Hey all,

Running into a what I thought should be a small problem but it’s going on an hour and I still can’t figure it out :jail:

Reading an excel file and running queries on Sheet names. The problem is when there is a single quote in the sheet name.

example:


selectQuery = "SELECT * FROM  Dave's Sheet"

It keeps bombing the query. Not matter what I try I can’t get this to work. I can’t replace the single quotes because then it can’t find the tab name. Any ideas?

Thanks