Recent content by IC113

  1. I

    OLEDB VBO Connection string for .xls file not working.

    As it turns out, with this issue the connection string was correct but although the file had file type as .xls, the data contained in the file was in .xml format. To check this you should right click on the file and open with notepad (or equivalent) and see if the file is in xls format. As a...
  2. I

    Solved where condition in SQL Query not working

    Can you give some more details of the query you are trying to complete, and the connection string you are using, as this doesnt give much data to help you out. Thanks, Ian
  3. I

    OLEDB VBO Connection string for .xls file not working.

    Hi, I have been using the OLEDB VBO in Blue Prism for a few weeks, and have it successfully pulling information from one set of sheets that have a .xlsx format using the connection string: "Provider=Microsoft.ACE.OLEDB.12.0;Data Source="&[File Path]&";Extended Properties=""Excel...
    • IC113
    • Thread
    • excel import oledb excel oledb vbo
    • Replies: 1
    • Forum: Blue Prism
See more
Top