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;

OR

select * from Alarms where 'Active' = 1;

OR

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.

Well I found the error was in using ;. No ; must be used.