I'm using Toad Data Point 18.104.22.1683 64 bit and Excel 64 bit. I'm getting this error when trying to send a query from Toad to an Excel instance. My office was recently updated to 64 bit so I'm not sure why I'm having this issue.
"Object type does not match target type. Export is cancelled."
Curious... since you recently upgraded your Office, you might have to install the 64-bit version of the Microsoft Database Access Engine components, but just guessing here. Would love to know what Quest Support says...
I agree, Gary. I think this is a good one to open with support/
Thanks for your input. After I applied a few more patches that came through our IT group everything is working again.