Known Issues

Microsoft Query has stopped working

You might receive this error when a SELECT statement includes a CAST function with the CAST value in quotes. To resolve this error, do not use quotes for the value in CAST functions of a SELECT statement while using MS Query for MS Excel 2016. For example, instead of the following statement:

SELECT CAST('123.45' AS REAL) FROM <table>

Use the following:

 SELECT CAST(123.45 AS REAL) FROM <table>

where 123.45 is the value without quotes.