I have several co-workers with Toad For SQL Server and there are 2 different versions in play. 5.7.0.065 and 6.00.323 and they are having the same issues exporting to Excel using the Excel Instance option to export data, but the Wizard option does work. They all have Excel 2007 on Windows 7.
The Error Message is: Object does not match target type. Export is cancelled.
Export Log:
8:53:22 AM Thread (6) Export Started [2/19/2015 8:53:22 AM]
8:53:22 AM Thread (6) Export using connection: SQLXXXXXXXXX-XX, XXXXX (XXXX\XXXXXX), dbXXX
8:53:22 AM Thread (6) Export using connection: SQLXXXXXXXXX-XX, XXXXX (XXXX\XXXXXX), dbXXX
8:53:22 AM Thread (6) Export Wizard: Building object list
8:53:22 AM Thread (6) Exporting Data (1 of 1)
8:53:22 AM Thread (6) Object Table Result Set started.
8:53:23 AM Thread (6) Object Table Result Set finished with error: Object does not match target type.
8:53:23 AM Thread (6) at System.Reflection.RuntimeMethodInfo.CheckConsistency(Object target)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.InitializeExcelPIA()
at Quest.Toad.ImportExport.Writers.WriterExcelInstance.WriteHeader(Object tableObject)
at Quest.Toad.ImportExport.ExportObjectData.StartTableWrite(Object context)
at Quest.Toad.ImportExport.ExportObjectData.Begin(LogEventHandler logEventHandler, Dictionary`2 connections, Object context)
8:53:29 AM Thread (6) Export Finished [2/19/2015 8:53:29 AM]
I did a search and found similar items for other Toad platforms and tried their examples, but no luck. Any idea’s?
Brian