Re: INSERT INTO...SELECT Issue

On Thu, Apr 19, 2018 at 4:26 PM, Paul H. Tarver paul@tpcqpc.com wrote:

Unfortunately, now the ODBC Driver is throwing an error:

    "[Microsoft][ODBC Excel Driver] Syntax error (missing operator) in

query expression '3rdPartySickPay'."

Unsurprisingly, ODBC thinks it's a dumb name for a field, too.

You'll probably need to "escape" it. I'm decades out of ODBC, so I don't recall if ODBC wants you to enclose the field name in single quotes, square brackets or back ticks (that `` funny key in the upper left corner no one ever uses). A web search might yield a suggestion, or you can just try the Usual Suspects...