oledb excel

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 ...