Contents x
    Syntax error in SQL statement at or about "Policy Policy 0" when Running Query in Excel from Progress ODBC in Microsoft Query
    • 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    Syntax error in SQL statement at or about "Policy Policy 0" when Running Query in Excel from Progress ODBC in Microsoft Query

    • Updated on 18 Jan 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    When querying the Progress database in Excel using the ODBC connection with Microsoft Query, the following error can occur:

    Syntax error in SQL statement at or about "Policy Policy 0". The table name will change depending on what table you are querying.

    Answer:

    This error occurs because the actual Progress database tables are being used rather than the SQL Views tables. The screenshots below are examples of one table.
     

    Choose the ODBC data source, Foundsql92 which is the Progress datasource:

    Log into the database: 

    Choose tables beginning with sql_ 

    Make any selections needed: 

    Choose to render data in Excel or query preview: 

    Results as shown in query preview: 

    Steps To Duplicate

    In MS Excel:

    Go to Data -> From Other Sources -> From Microsoft Query -> Select “Foundsql92*” data source -> Enter FIMS login/pwd -> Select “Policy” table -> try to select any data element -> Error message


    Was this article helpful?
    What's Next