Toad World® Forums

Can no longer use Quick Export


#1

I am working on a Win 7 platform with Toad for SQL Server 5.7.0.605 and MS Office 2007. The company moved to Sharepoint 2010 and I was recently tasked to develop a SharePoint app and installed the SharePoint Designer. Since I installed this program, I am no longer able to use the quick export function. I get the error **“Object does not match target type. Export is cancelled.” ** I can only export using either the Export Wizard or Export to File. While those are an option, the quick export is much more productive.

A couple of co-workers and I are thinking it might have to do with mis-matches in MS Office editions…as another got this issue when they installed a newer version of MS Visio.

Here is the Event Log:

4:52:49 PM Thread (23) Export Started [5/9/2015 4:52:49 PM]
4:52:49 PM Thread (23) Export using connection: <Database\User>
4:52:49 PM Thread (23) Export using connection: <Database\User>
4:52:49 PM Thread (23) Export Wizard: Building object list
4:52:49 PM Thread (23) Exporting Data (1 of 1)
4:52:49 PM Thread (23) Object Table Result Set started.

4:52:50 PM Thread (23) Object Table Result Set finished with error: Object does not match target type.

4:52:50 PM Thread (23) 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)
4:53:52 PM Thread (23) Export Finished [5/9/2015 4:53:52 PM]

Anyone have an idea on how to address this outside of re-installing Toad? Not even sure that will work.

Brian


#2

I located a fix in the corporate IT that worked. It was an issue with MS Office versions and I have asked them for the specific MS # so I can post it. The fix was for when a user installed a 2010 version of Visio and had Office 2007 installed. It did not seem to care that I did not have Visio installed.