Problem:
When you try to download a file to a Microsoft Excel spreadsheet using the Microsoft Excel ODBC driver, you get the following error:
-3502: 37000: [Microsoft][ODBC Excel Driver] Syntax error in INSERT INTO statement.
Solution:
This error occurs when you create a named range in the Microsoft Excel spreadsheet that contains a column name that conflicts with any of the standard SQL keywords such as: ORDER, WHERE, OR, AND, and so on.
Make sure that none of the column names in the named range conflict with any of the standard SQL keywords.
Last Modified On:
No, open a new Support Case