Announcement

Collapse
No announcement yet.

DataReader and Excel

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DataReader and Excel

    I need to use datareader to get info from an excel spreadsheet, I am getting the following error,

    Error
    Code = 0x800a.e7a
    Code Meaning = Unknown error 0x400A0E7A
    Source = ADODM.Connection
    Description = Provider cannot be found. It may not be properly installed.


    Anyone has any idea what this means and better yet how to fix it.

    Thanks

  • #2
    Please check whether the MS Excel is installed on the system...

    Comment


    • #3
      Its not installed, does it need to be? is there another way to do it, without having to install MS Excel?

      Comment


      • #4
        Then install it because ADO will need MS Excel DLLs to get the data from the Excel Sheet.

        Comment


        • #5
          I did install, it is the 365 version, and still got the same error, any other ideas?

          Comment


          • #6
            Did you ever get a response to this?

            Comment


            • #7
              I never did, I had to use a script to get the data I needed

              Comment


              • #8
                Can you share the script? i will probably need to do the same.

                Comment

                Working...
                X