none
Unable to create an Excel Connection Manager not recognized as a valid connection type. RRS feed

  • Question

  • Suddenly, after the most recent Microsoft update (day before yesterday), SSIS no longer recognizes Excel as a valid connection manager type. The SSIS packages have been working well for over a year.   Here is the error message

    The connection type "EXCEL, {8FD37A45-01A4-210C-6C6D-575139717076}" specified for connection manager "{F118BC96-4456-4B60-A69F-1E69A7BACCFF}" 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.

    ------------------------------

    In SSMS, I clicked on on of the databases and selected Task, then import data, select Excel, and I see this error immediately.

    I'm running SQL Server 2017 and the most current version of SSDT (just downloaded and installed as an attempt to fix this issue).  The machine is 64-bit Windows 2012 R2.

    I'm running Microsoft Office 365 64-bit, but again, things have been running perfectly until today with SSIS accessing Excel.

    My guess is that something, perhaps in yesterday's Windows update corrupted, whatever it is that SSDT needs to connect to an Excel data source, but that's only a guess.

    I have installed the 64-bit versions of 

    Microsoft.ACE.OLEDB.12.0

    Microsoft.ACE.OLEDB.15.0

    Microsoft.ACE.OLEDB.16.0

    Any possible solution?  Is there something I need to reinstall?  Please advise.

    Saturday, January 18, 2020 1:54 AM

All replies

  • If possible, please share what were those windows updates (number/KB/name) that made excel connection stopped working. I have seen other 2 threads raised by you. Hopefully this get resolved soon. 

    If the response helped, do "Mark as answer" and upvote it
    - Vaibhav

    Sunday, January 19, 2020 6:39 PM