Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Syntax Error
I am querying an external database and get a syntax error message that looks
like: SELECT CMT REGISTER_TRANSACTION.Bank_Account, CMT_REGISTER_TRANSACTION.Check<<???, etc, etc. FROM CMT_REGISTER_TRANSACTION CMT_REGISTER_TRANSACTION WHERE (CMT_REGISTER_TRANSACTION.Bank_Account='4001') Syntax Error. The problem seems to be the "check" field because if I remove it, the data is retrieved. Have checked the ODBC connections and also confirmed if there are custom descriptions for the "check" field. Everything seems to be in order. Have also tried querying other tables in the external database & have no problems. Wondering what could be causing Excel to return a syntax error message on this field. Thanks, Cheryl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
syntax error - help | Excel Discussion (Misc queries) | |||
runtime error: syntax error or access violation | Excel Programming | |||
runtime error: syntax error or access violation | Excel Programming | |||
variable not declared error & syntax error | Excel Programming | |||
Syntax Error Runtime Error '424' Object Required | Excel Programming |