How to deal with single quote in Word VBA SQL query?

by

Where you specify two single quotes '', one will escape the other and will result in single, try to replace it like this:

customerName = Replace(customerName, "'", "''")

More Related Contents:

  1. SQL Query output in VBA is different than in SQL Oracle
  2. How do I use parameters in VBA in the different contexts in Microsoft Access?
  3. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  4. Performing SQL queries on an Excel Table within a Workbook with VBA Macro
  5. Using Excel VBA to export data to MS Access table
  6. Accessing SQL Database in Excel-VBA
  7. Excel function to make SQL-like queries on worksheet data?
  8. Using Excel VBA to run SQL query
  9. How to use system username directly in MS Access query?
  10. Access – compare two tables and update or insert data in first table
  11. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  12. How do I call an Oracle stored procedure from an Excel VBA script?
  13. How to save the result of a SQL query into a variable in VBA?
  14. Escaping ‘ in Access SQL
  15. How to Write SQL funtion
  16. Is it possible to insert multiple rows at a time in an SQLite database?
  17. What is SELF JOIN and when would you use it? [duplicate]
  18. Spark Window Functions – rangeBetween dates
  19. “CASE” statement within “WHERE” clause in SQL Server 2008
  20. SQL Server – How to lock a table until a stored procedure finishes
  21. How to create a unique index on a NULL column?
  22. Serial numbers per group of rows for compound key
  23. Difference between datetime and timestamp in sqlserver? [duplicate]
  24. How to count instances of character in SQL Column
  25. Meaning of square brackets [] in MS-SQL table designer? [duplicate]
  26. Check if current date is between two dates Oracle SQL
  27. convert Postgres geometry format to WKT
  28. SQL query that gives distinct results that match multiple columns
  29. SQL Server Convert integer to binary string
  30. create custom function for date difference excluding weekends and holidays in oracle sql

Leave a Comment