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 ?