Tuesday, October 23, 2012

SSIS : Test connection failed because of an error in initializing provider. Unrecognized database format

Test connection failed because of an error in initializing provider. Unrecognized database format 'C:\Testdata.xlsx'.

 
If you encounter excel connection error then we need to type Excel 12.0 on Extended properties as below
 

 
Posted by

1 comment:

  1. ChristopherSeptember 8, 2014 at 8:48 AM

    Hi Kalyan,

    Came across your blog looking for a solution with the screenshot above.

    I'm trying to link a .accdb to a .xlsm file, and tried the method above: both by typing Excel 12.0 or Excel 14.0, but it is still not working.

    Would you have any other ideas?

    ReplyDelete

Subscribe to: Post Comments (Atom)