When using Excel 2003 and when trying to export data to create an Excel instance with a linked query, the following error appears:
'Object does not match target type.'
The error appears when clicking Quick Export | Linked query to an excel instance | Excel linked query.
This issue is caused when using Excel 2003.
Download and install the Microsoft Office 2007 compatibility pack.