Syntax error in INSERT INTO statement

 

When you try to download a file to a Microsoft Excel spreadsheet using the Microsoft Excel ODBC driver, you get the following error:

 

 

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.