Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-18 : 09:04:43
|
| Brian writes "Hi,I get the exception below only on selecting the Microsoft Excel drivers to import data from an Excel sheet on the ‘Chose a Data Source’ screen. This subsequently prevents an Excel data import.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 "{0DDD14C7-AA5F-442B-84BF-C60F43A94144}" 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. ({44769758-E6E4-4AD3-8CF7-C446EFC03298})-----------------------------The connection type "EXCEL" specified for connection manager "{0DDD14C7-AA5F-442B-84BF-C60F43A94144}" 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. ({44769758-E6E4-4AD3-8CF7-C446EFC03298})I’ve re-installed MDAC 2.8 but it hasn’t solved the problem on my PC. What is the cause and solution for this error?" |
|
|
|
|
|
MS SQL Server Excel Driver Exception