While attempting to import data from Excel using SSMS and the import/export wizard, I received the following error:
TITLE: SQL Server Import and Export Wizard
An error occurred which the SQL Server Integration Services Wizard was not prepared to handle.
ADDITIONAL INFORMATION:
Exception has been thrown by the target of an invocation. (mscorlib)
The connection type "EXCEL" specified for connection manager "{11CD789E-0DCD-48C8-81F9-1065D87B5ADF}" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
({BB3EBEA7-7F0E-4346-A8A5-60E176732365})
Any clues as what causes this and how to resolve the problem. I am using Office XP.
import from Excel error
Bent
Rod Kimmel
Do you have Microsoft Jet OLE DB provider installed It should be there by default. Check whether you are missing msjetoledb40.dll, or whether it is correctly registered may help.
HTH
wenyang