I can successfully pull up the data into Excel using ODBC connection. The SQL statement like
select * from Alarms;
is working perfectly fine. The issue is when I use 'where' statement, I get an error. The following command is giving an error.
select * from Alarms where Active = 1;
select * from Alarms where 'Active' = 1;
select * from Alarms where Active = '1';
I noticed "where" clause is not working at all in all other queries as well. Please let me know what is the reason. Any workaround.