List of characters that are will not work in SQL string and how to use them

[pharmacologist]

Is there a compiled list of all the special characters that cannot be used in a SQL string or stored as a value by SQL query and how to use them? I have tables of excel data that include many different symbols and am having a difficult time getting the query to not error out and I think it's due to these characters.

[orange]

Not aware of such a list. Can you show us one of your problem queries?

[Bulzie]

One trick say for special characters in text fields is using 3 and 4 quotes in stead of the 1 and 2. Like:

= """ & Me!MyField & """"

You could also do a Replace function on the field to change special characters if needed to regular text maybe.