Forum Discussion

kktsenthil's avatar
kktsenthil
Occasional Contributor
10 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
10 years ago

now i used old excel format it works,..

  • jorgesimoes1983's avatar
    jorgesimoes1983
    Regular Contributor
    10 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
      10 years ago

      I have installed the 'ACE DRIVER'..

      Thanks!