SQLTeam.com | Weblogs | Forums

Unable to connect to the excel or msaccess file in SSIS



Hi all

Just started MSBI ,very new

I am trying to connect to excel source..But its shows an error any idea ? or suggestion ?


Did you configure an 'Excel Connection Manager'? It looks as if it's prompting you to set one up.


sorry, configuring excel ?

i installed odbc drivers .i will try to check in google configuring excel manager

same error ,please suggest how to resolve

please help


A similar usecase is covered in this sql server solution page. If you are still having a trouble, you should try the following driver . You will be able to find the relevant documentation at the bottom of this page.


please post a screen shot of your excel spreadsheet ?