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!