On Thu, Apr 19, 2018 at 4:26 PM, Paul H. Tarver <[email protected]> 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... -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cacw6n4tx4y1c_2symc6c_ydcv10p0l2+lwqnwlom9vg0tdx...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
