While exporting some queries in MS Access to Excel, I got this error on one of them.

For those who are having the same problem, please check the name of the tables, possibly it contains reserved words. In my case I got word “IN” as table name and that triggers error.