Microsoft KB Archive/95757

{| = Q+E Err Msg: &quot;Error in SQL Statement&quot; =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q95757 The information in this article applies to:
 * Q+E version 3.0 for Microsoft Excel for Windows
 * Q+E version 3.0 for Microsoft Excel for OS/2

SUMMARY
When you use the QE.XLA add-in macro to extract data from an external database in Microsoft Excel, you may receive the error message &quot;Error in SQL Statement&quot; if there is a mismatched data type in one of the criteria fields.

MORE INFORMATION
You can use the QE.XLA add-in macro to extract data from external databases and place it in a Microsoft Excel worksheet. However, if a criteria field contains a mismatched data type, such as a numeric value in a criteria field that requires the text data type, the error message &quot;Error In SQL Statement&quot; will be displayed when you choose Extract from the Data menu. When this error occurs, data will not be returned to the Microsoft Excel worksheet.