INSERT/UPDATE: Allow the special characters ', &, and ; in SQL …
https://bioticssupport.natureserve.org/support/solutions/articles/201031-insert-update-allow-the-special-characters-and-in-sql-insert-and-update-statements
Apr 09, 2018 · NOTE: to have macros always available in Excel, store them in a file named personal.xls in the XLStart folder. Sub Add_quotes() 'For data in each selected cell, 'enclose in single quotes, replace ' with '', and trim outside spaces '(to prepare text for SQL insert statements) For Each c In Selection.Cells If IsNull(c.Value) Or Trim(c.Value ...
DA: 73 PA: 81 MOZ Rank: 15