From this web page, 2015, I copied the table and pasted into Calc.
There is an apostrophe in cell E22 which is misspelling and has a conflict with ' in SQL statement.
This statement is not correct,
HolidayName = Replace(oSheet.GetCellByPosition(4,r).String,"'","’")
Help me please.
To escape an apostrophe for an SQL query double it, like Queen''s.
And you should really make sure your data doesn’t result in an SQL injection…
Dear @erAck ,
From the image, the apostrophe in cell E20 or E24, has no problem.
The problem with SQL statement is in cell E22, the apostrophe in it, is different from in cell E20 and E24.