oledb excel

  1. R

    OLE DB Filter Excel Data

    Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...
  2. R

    OLE DB Filter Excel Data

    Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...
  3. R

    OLE DB Filter Excel Data

    Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...
  4. R

    OLE DB Filter Excel Data

    Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...
  5. R

    OLE DB Filter Excel Data

    Hi everyone! Hope you are doing well! I want to extract data from Excel but only rows that start with, for ex: "#DET;2021;01;04". There are a lot of rows with that initial string and I want them into a collection. I've tried using Filter Collection but takes to long and sometimes the BP shuts...
  6. F

    Blue Prism changes extracted date to previous date while reading from Excel(using OLEDB)

    Hello Everyone, I am trying to read date from a particular cell(Date format) in Excel(using OLEDB). Whenever the date is read, in the output the date changes to its previous day. Eg:- If the date in the cell is 17/02/2021 after reading in Blue Prism the output shows 16/02/2021. If...
  7. J

    Excel OLEDB - Invalid SQL Statement

    I'm trying to pull a simple --- Select * From [Excel Sheet] Could not execute code stage because exception thrown by code stage: Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'. I'm trying to use various versions of the following statement. With [Excel...
  8. J

    Excel OLEDB connection, number format

    Hi, We are developing a robot to automate some reporting analysis and submission to different process owner. Basically we extract data from SAP, make some mapping query in access and then extract data into excel in different report to different user. To write in excel we are using connection...
  9. H

    Data Extraction From Excel Using OLEDB

    Hi All, I need help on extracting data from Excel file. I cannot use MS Excel VBO - because Sheet has more than 10 duplicate column names(but data inside them is different). So if I try to extract using Excel VBO I get an error stating column name already exists in the data table. So I tried...
  10. 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...
  11. P

    Update Column in Excel using OLEDB

    Hi Did any one use Update query to update column with a formula in Excel, Excel was like 160K Rows of data, SO it taking time to update using other ways , Pls help me out if any one did update query , I am trying but getting error , my connection string was correct (as tested using get...
  12. K

    Excel Update using OLEDB

    Hello All I am working on updating the excel using oledb query it is working for other cells but for one cell updation it is giving error as "Internal : Could not execute code stage because exception thrown by code stage: No value given for one or more required parameter" Connection string ...
Top