>Thread-Topic: Exception trying to import data from Excel .
>thread-index: AcY9aoUve4FjMD2oRuCRoGREQJdwgw==
>X-WBNR-Posting-Host: 143.166.226.16
>From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
>Subject: Exception trying to import data from Excel .
>Date: Wed, 1 Mar 2006 11:58:33 -0800
>Lines: 39
>Message-ID: <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>    charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.tools
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29869
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>
>Hello,
>
>I am running SQL Management Studio and was trying to import excel data
into
>a table on my local 2005 database.  When I choose the import task then
choose
>Excel as the data source I get this lovely message:
>
>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
>"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> ({06C927B9-F2F2-429B-B488-591883AE4655})
>
>------------------------------
>
>The connection type "EXCEL" specified for connection manager
>"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> ({06C927B9-F2F2-429B-B488-591883AE4655})
>
>I have searched the net (google and groups) and have come up with nothing.

>Any ideas would be greatly appreciated.
>--
>Rich
>

"Peter Yang [MSFT]" wrote:

> Hello Rich,
>
> It seems there is some issues in SSIS related components are not registered
> properly. You may want to try the following:
>
>  Bring up a command prompt and 
> -- go to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
> -- type below to unregister:
> regsvr32.exe -u dtsconn.dll 
>
> --Then type below to register: 
> regsvr32.exe dtsconn.dll 
>
> If the issue persists, please ensure the Users (machinename\Users) have
> Full Control on the
> HKEY_CLASSES_ROOT\CLSID\.
> In fact, you should go to PERMISSION-->ADVANCE
>  Ensure machinename\Users have full control  permission.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> >Thread-Topic: Exception trying to import data from Excel .
> >thread-index: AcY9aoUve4FjMD2oRuCRoGREQJdwgw==
> >X-WBNR-Posting-Host: 143.166.226.16
> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
> >Subject: Exception trying to import data from Excel .
> >Date: Wed, 1 Mar 2006 11:58:33 -0800
> >Lines: 39
> >Message-ID: <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> >    charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.tools
> >Path: TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29869
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >X-Tomcat-NG: microsoft.public.sqlserver.tools
> >
> >Hello,
> >
> >I am running SQL Management Studio and was trying to import excel data
> into
> >a table on my local 2005 database.  When I choose the import task then
> choose
> >Excel as the data source I get this lovely message:
> >
> >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
> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> > ({06C927B9-F2F2-429B-B488-591883AE4655})
> >
> >------------------------------
> >
> >The connection type "EXCEL" specified for connection manager
> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> > ({06C927B9-F2F2-429B-B488-591883AE4655})
> >
> >I have searched the net (google and groups) and have come up with nothing.
> 
> >Any ideas would be greatly appreciated.
> >--
> >Rich
> >
>
>

>Subject: RE: Exception trying to import data from Excel .
>Date: Wed, 1 Mar 2006 19:56:27 -0800
>Lines: 167
>Message-ID: <ADECD008-AC46-4800-B932-121744E9B***@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>    charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.tools
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29881
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>
>Peter,
>
>Thanks for the quick response.  I tried what you said (unregister and
>re-register) and it yeilded no results.  I then applied the registry
>permisison (while SQL Management studio was open and the error was on the
>screen) to the CLSID folder (giving Users full control).  I then tried the
>operation again and got a message saying something to the effect of Server
>Name Unknown (sorry I didnt think to write it down).  So I closed the SQL
>Management studio and re-opened it.  When I tried again, I got a similar
>message to the first time I tried but it had different CLSID's.  I have
>attached the message below.
>
>One other thing to note, I noticed that I also do not have the drivers to
be
>able to read in such things as flat files.  On a co-workers computer it
>appears between the first .net dirvers and the media catalog drivers.  I
am
>not sure if te two are related but I thought I would bring it up.
>
>Lastly before, you replied today, I uninstalled SQL Server and the tools
and
>then re-installed.  Still nothing.
>
>Message follows:
>
>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
>"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
> ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
>
>------------------------------
>
>The connection type "EXCEL" specified for connection manager
>"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
> ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
>
>------------------------------
>BUTTONS:
>
>OK
>------------------------------
>
>
>--
>Rich
>
>
>"Peter Yang [MSFT]" wrote:
>
>> Hello Rich,
>>
>> It seems there is some issues in SSIS related components are not
registered
>> properly. You may want to try the following:
>>
>>  Bring up a command prompt and 
>> -- go to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
>> -- type below to unregister:
>> regsvr32.exe -u dtsconn.dll 
>>
>> --Then type below to register: 
>> regsvr32.exe dtsconn.dll 
>>
>> If the issue persists, please ensure the Users (machinename\Users) have
>> Full Control on the
>> HKEY_CLASSES_ROOT\CLSID\.
>> In fact, you should go to PERMISSION-->ADVANCE
>>  Ensure machinename\Users have full control  permission.
>>
>> Best Regards,
>>
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>>
>> =====================================================
>>
>>
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>>
>>
>> --------------------
>> >Thread-Topic: Exception trying to import data from Excel .
>> >thread-index: AcY9aoUve4FjMD2oRuCRoGREQJdwgw==
>> >X-WBNR-Posting-Host: 143.166.226.16
>> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
>> >Subject: Exception trying to import data from Excel .
>> >Date: Wed, 1 Mar 2006 11:58:33 -0800
>> >Lines: 39
>> >Message-ID: <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> >    charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.tools
>> >Path: TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29869
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >X-Tomcat-NG: microsoft.public.sqlserver.tools
>> >
>> >Hello,
>> >
>> >I am running SQL Management Studio and was trying to import excel data
>> into
>> >a table on my local 2005 database.  When I choose the import task then
>> choose
>> >Excel as the data source I get this lovely message:
>> >
>> >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
>> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
>> > ({06C927B9-F2F2-429B-B488-591883AE4655})
>> >
>> >------------------------------
>> >
>> >The connection type "EXCEL" specified for connection manager
>> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
>> > ({06C927B9-F2F2-429B-B488-591883AE4655})
>> >
>> >I have searched the net (google and groups) and have come up with
nothing.
>> 
>> >Any ideas would be greatly appreciated.
>> >--
>> >Rich
>> >
>>
>>
>

"Peter Yang [MSFT]" wrote:

> Hello Rich,
>
> It seems that oledb related driver has issues on this server. I suggest
> that you try the following steps:
>
> 1. Reinstall MDAC by right clicking %windir%\inf\mdac.inf->Install to
> reinstall MDAC. You may prompt to insert Win2003 setup CD.
>
> 2. Reinstall  Jet SP8 on your server:
>
> 239114:  How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
> http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
>
> Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> >Thread-Topic: Exception trying to import data from Excel .
> >thread-index: AcY9rUgr1ynjYsVLQnuskA4GOXAWCw==
> >X-WBNR-Posting-Host: 70.123.136.122
> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
> >References:  <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
> <53c43gaPGHA.8***@TK2MSFTNGXA03.phx.gbl>
> >Subject: RE: Exception trying to import data from Excel .
> >Date: Wed, 1 Mar 2006 19:56:27 -0800
> >Lines: 167
> >Message-ID: <ADECD008-AC46-4800-B932-121744E9B***@microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> >    charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.tools
> >Path: TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29881
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >X-Tomcat-NG: microsoft.public.sqlserver.tools
> >
> >Peter,
> >
> >Thanks for the quick response.  I tried what you said (unregister and
> >re-register) and it yeilded no results.  I then applied the registry
> >permisison (while SQL Management studio was open and the error was on the
> >screen) to the CLSID folder (giving Users full control).  I then tried the
> >operation again and got a message saying something to the effect of Server
> >Name Unknown (sorry I didnt think to write it down).  So I closed the SQL
> >Management studio and re-opened it.  When I tried again, I got a similar
> >message to the first time I tried but it had different CLSID's.  I have
> >attached the message below.
> >
> >One other thing to note, I noticed that I also do not have the drivers to
> be
> >able to read in such things as flat files.  On a co-workers computer it
> >appears between the first .net dirvers and the media catalog drivers.  I
> am
> >not sure if te two are related but I thought I would bring it up.
> >
> >Lastly before, you replied today, I uninstalled SQL Server and the tools
> and
> >then re-installed.  Still nothing.
> >
> >Message follows:
> >
> >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
> >"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
> > ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
> >
> >------------------------------
> >
> >The connection type "EXCEL" specified for connection manager
> >"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
> > ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
> >
> >------------------------------
> >BUTTONS:
> >
> >OK
> >------------------------------
> >
> >
> >--
> >Rich
> >
> >
> >"Peter Yang [MSFT]" wrote:
> >
> >> Hello Rich,
> >>
> >> It seems there is some issues in SSIS related components are not
> registered
> >> properly. You may want to try the following:
> >>
> >>  Bring up a command prompt and 
> >> -- go to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
> >> -- type below to unregister:
> >> regsvr32.exe -u dtsconn.dll 
> >>
> >> --Then type below to register: 
> >> regsvr32.exe dtsconn.dll 
> >>
> >> If the issue persists, please ensure the Users (machinename\Users) have
> >> Full Control on the
> >> HKEY_CLASSES_ROOT\CLSID\.
> >> In fact, you should go to PERMISSION-->ADVANCE
> >>  Ensure machinename\Users have full control  permission.
> >>
> >> Best Regards,
> >>
> >> Peter Yang
> >> MCSE2000/2003, MCSA, MCDBA
> >> Microsoft Online Partner Support
> >>
> >> When responding to posts, please "Reply to Group" via your newsreader so
> >> that others may learn and benefit from your issue.
> >>
> >> =====================================================
> >>
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >>
> >>
> >> --------------------
> >> >Thread-Topic: Exception trying to import data from Excel .
> >> >thread-index: AcY9aoUve4FjMD2oRuCRoGREQJdwgw==
> >> >X-WBNR-Posting-Host: 143.166.226.16
> >> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
> >> >Subject: Exception trying to import data from Excel .
> >> >Date: Wed, 1 Mar 2006 11:58:33 -0800
> >> >Lines: 39
> >> >Message-ID: <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
> >> >MIME-Version: 1.0
> >> >Content-Type: text/plain;
> >> >    charset="Utf-8"
> >> >Content-Transfer-Encoding: 7bit
> >> >X-Newsreader: Microsoft CDO for Windows 2000
> >> >Content-Class: urn:content-classes:message
> >> >Importance: normal
> >> >Priority: normal
> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >> >Newsgroups: microsoft.public.sqlserver.tools
> >> >Path: TK2MSFTNGXA03.phx.gbl
> >> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29869
> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >> >X-Tomcat-NG: microsoft.public.sqlserver.tools
> >> >
> >> >Hello,
> >> >
> >> >I am running SQL Management Studio and was trying to import excel data
> >> into
> >> >a table on my local 2005 database.  When I choose the import task then
> >> choose
> >> >Excel as the data source I get this lovely message:
> >> >
> >> >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
> >> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> >> > ({06C927B9-F2F2-429B-B488-591883AE4655})
> >> >
> >> >------------------------------
> >> >
> >> >The connection type "EXCEL" specified for connection manager
> >> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
> >> > ({06C927B9-F2F2-429B-B488-591883AE4655})
> >> >
> >> >I have searched the net (google and groups) and have come up with
> nothing.
> >> 
> >> >Any ideas would be greatly appreciated.
> >> >--
> >> >Rich
> >> >
> >>
> >>
> >
>
>

>Subject: RE: Exception trying to import data from Excel .
>Date: Thu, 2 Mar 2006 07:44:29 -0800
>Lines: 247
>Message-ID: <FF059899-A260-49CC-85F8-134D3D7F7***@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>    charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.tools
>Path: TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29886
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>X-Tomcat-NG: microsoft.public.sqlserver.tools
>
>Peter,
>
>You are a genius.  Thanks a million.  I re-installed the MDAC inf and
>everything started working again.  Thank you so much.  I have a task where
I
>REALLY needed to be able to import some xls/csv spreadsheets and was not
>looking forward to having to write the code to do it myself.
>
>Thanks again.
>--
>Rich
>
>
>"Peter Yang [MSFT]" wrote:
>
>> Hello Rich,
>>
>> It seems that oledb related driver has issues on this server. I suggest
>> that you try the following steps:
>>
>> 1. Reinstall MDAC by right clicking %windir%\inf\mdac.inf->Install to
>> reinstall MDAC. You may prompt to insert Win2003 setup CD.
>>
>> 2. Reinstall  Jet SP8 on your server:
>>
>> 239114:  How To: Obtain the Latest Service Pack for the Microsoft Jet
4.0
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;239114
>>
>> Regards,
>>
>> Peter Yang
>> MCSE2000/2003, MCSA, MCDBA
>> Microsoft Online Partner Support
>>
>> When responding to posts, please "Reply to Group" via your newsreader so
>> that others may learn and benefit from your issue.
>>
>> =====================================================
>>
>>
>> This posting is provided "AS IS" with no warranties, and confers no
rights.
>>
>>
>> --------------------
>> >Thread-Topic: Exception trying to import data from Excel .
>> >thread-index: AcY9rUgr1ynjYsVLQnuskA4GOXAWCw==
>> >X-WBNR-Posting-Host: 70.123.136.122
>> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
>> >References:  <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
>> <53c43gaPGHA.8***@TK2MSFTNGXA03.phx.gbl>
>> >Subject: RE: Exception trying to import data from Excel .
>> >Date: Wed, 1 Mar 2006 19:56:27 -0800
>> >Lines: 167
>> >Message-ID: <ADECD008-AC46-4800-B932-121744E9B***@microsoft.com>
>> >MIME-Version: 1.0
>> >Content-Type: text/plain;
>> >    charset="Utf-8"
>> >Content-Transfer-Encoding: 7bit
>> >X-Newsreader: Microsoft CDO for Windows 2000
>> >Content-Class: urn:content-classes:message
>> >Importance: normal
>> >Priority: normal
>> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >Newsgroups: microsoft.public.sqlserver.tools
>> >Path: TK2MSFTNGXA03.phx.gbl
>> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29881
>> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >X-Tomcat-NG: microsoft.public.sqlserver.tools
>> >
>> >Peter,
>> >
>> >Thanks for the quick response.  I tried what you said (unregister and
>> >re-register) and it yeilded no results.  I then applied the registry
>> >permisison (while SQL Management studio was open and the error was on
the
>> >screen) to the CLSID folder (giving Users full control).  I then tried
the
>> >operation again and got a message saying something to the effect of
Server
>> >Name Unknown (sorry I didnt think to write it down).  So I closed the
SQL
>> >Management studio and re-opened it.  When I tried again, I got a
similar
>> >message to the first time I tried but it had different CLSID's.  I have
>> >attached the message below.
>> >
>> >One other thing to note, I noticed that I also do not have the drivers
to
>> be
>> >able to read in such things as flat files.  On a co-workers computer it
>> >appears between the first .net dirvers and the media catalog drivers. 
I
>> am
>> >not sure if te two are related but I thought I would bring it up.
>> >
>> >Lastly before, you replied today, I uninstalled SQL Server and the
tools
>> and
>> >then re-installed.  Still nothing.
>> >
>> >Message follows:
>> >
>> >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
>> >"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
>> > ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
>> >
>> >------------------------------
>> >
>> >The connection type "EXCEL" specified for connection manager
>> >"{586BE7D4-F968-4585-9DE7-DAEDAD067CF3}" 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.
>> > ({38BF22B4-3036-4BAB-9177-4820DA4EE187})
>> >
>> >------------------------------
>> >BUTTONS:
>> >
>> >OK
>> >------------------------------
>> >
>> >
>> >--
>> >Rich
>> >
>> >
>> >"Peter Yang [MSFT]" wrote:
>> >
>> >> Hello Rich,
>> >>
>> >> It seems there is some issues in SSIS related components are not
>> registered
>> >> properly. You may want to try the following:
>> >>
>> >>  Bring up a command prompt and 
>> >> -- go to C:\Program Files\Microsoft SQL Server\90\DTS\Binn
>> >> -- type below to unregister:
>> >> regsvr32.exe -u dtsconn.dll 
>> >>
>> >> --Then type below to register: 
>> >> regsvr32.exe dtsconn.dll 
>> >>
>> >> If the issue persists, please ensure the Users (machinename\Users)
have
>> >> Full Control on the
>> >> HKEY_CLASSES_ROOT\CLSID\.
>> >> In fact, you should go to PERMISSION-->ADVANCE
>> >>  Ensure machinename\Users have full control  permission.
>> >>
>> >> Best Regards,
>> >>
>> >> Peter Yang
>> >> MCSE2000/2003, MCSA, MCDBA
>> >> Microsoft Online Partner Support
>> >>
>> >> When responding to posts, please "Reply to Group" via your newsreader
so
>> >> that others may learn and benefit from your issue.
>> >>
>> >> =====================================================
>> >>
>> >>
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> >>
>> >>
>> >> --------------------
>> >> >Thread-Topic: Exception trying to import data from Excel .
>> >> >thread-index: AcY9aoUve4FjMD2oRuCRoGREQJdwgw==
>> >> >X-WBNR-Posting-Host: 143.166.226.16
>> >> >From: "=?Utf-8?B?UmljaCBEZW5pcw==?=" <cojones@community.nospam>
>> >> >Subject: Exception trying to import data from Excel .
>> >> >Date: Wed, 1 Mar 2006 11:58:33 -0800
>> >> >Lines: 39
>> >> >Message-ID: <61A56959-4BBB-4267-BDF9-D2CACA3AF***@microsoft.com>
>> >> >MIME-Version: 1.0
>> >> >Content-Type: text/plain;
>> >> >    charset="Utf-8"
>> >> >Content-Transfer-Encoding: 7bit
>> >> >X-Newsreader: Microsoft CDO for Windows 2000
>> >> >Content-Class: urn:content-classes:message
>> >> >Importance: normal
>> >> >Priority: normal
>> >> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>> >> >Newsgroups: microsoft.public.sqlserver.tools
>> >> >Path: TK2MSFTNGXA03.phx.gbl
>> >> >Xref: TK2MSFTNGXA03.phx.gbl microsoft.public.sqlserver.tools:29869
>> >> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>> >> >X-Tomcat-NG: microsoft.public.sqlserver.tools
>> >> >
>> >> >Hello,
>> >> >
>> >> >I am running SQL Management Studio and was trying to import excel
data
>> >> into
>> >> >a table on my local 2005 database.  When I choose the import task
then
>> >> choose
>> >> >Excel as the data source I get this lovely message:
>> >> >
>> >> >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
>> >> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
>> >> > ({06C927B9-F2F2-429B-B488-591883AE4655})
>> >> >
>> >> >------------------------------
>> >> >
>> >> >The connection type "EXCEL" specified for connection manager
>> >> >"{2D54D28C-42CF-4614-ADB6-371E9E4F927D}" 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.
>> >> > ({06C927B9-F2F2-429B-B488-591883AE4655})
>> >> >
>> >> >I have searched the net (google and groups) and have come up with
>> nothing.
>> >> 
>> >> >Any ideas would be greatly appreciated.
>> >> >--
>> >> >Rich
>> >> >
>> >>
>> >>
>> >
>>
>>
>