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.

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016