Forum Discussion

kktsenthil's avatar
kktsenthil
Occasional Contributor
11 years ago

Unable to retrieve the worksheet list from the specified workbook.

Unable to retrieve the worksheet list from the specified workbook. The following error occurred:  Provider cannot be found. It may not be properly installed
kktsenthil's avatar
kktsenthil
Occasional Contributor
11 years ago

now i used old excel format it works,..

jorgesimoes1983's avatar
jorgesimoes1983
Regular Contributor
11 years ago

Nice, glad to see you worked it out.

 

If you want to use the new excel format, you must use ACE DRIVER instead of ODBC DRIVER.

 

Although I always used ODBC without any issues.

  • kktsenthil's avatar
    kktsenthil
    Occasional Contributor
    11 years ago

    I have installed the 'ACE DRIVER'..

    Thanks!