oledb

  1. T

    Microsoft Excel Data Connections - Alter Command Text

    Hi everyone, I'm trying to change Command Text box in Connection Properties (see picture). It is an existing data connection in Excel and I need to change the query. I already found this thread discussing altering Connection String but I was not able to alter the code for my purposes. What...
  2. J

    OLEDB - Text File - Pipe Delimited

    Hello, Has anyone used an OLEDB connection to work with a text file? If so have you done so on a Pipe Delimited File? Any insight appreciated. Jon
  3. S

    System out of memory exception when getting excel data even on using OLEDB

    I have a requirement to identify first empty column out of the filtered records. Excel 1= 7k rows and 1k columns Upon applying filter criteria it will be max of 3 to 4 rows with 1000 columns. For 1 employee If am not able to find empty columns for filtered records(3 to 4) from excel 1 then...
  4. M

    OLEDB with Excel

    Hi team, Am using OLEDB with Excel (Office 365). When am giving the connection string, its working fine. But when executing the connection, it shows " Error: db_sec_e_auth_failed(0x80040E4D)" error, Can someone help me on this.
  5. 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...
  6. P

    Update query

    Hi , Did any one tried update query in Oledb-execute action? Please reply here. I am getting error while using it. Iam trying to update a column in excel using oledb. Pls help Thanks
  7. B

    External Table is not in the expected format ...Error while using OLEDB in Blue prism

    Hi Experts, I am using OLEDB in my process and running the process in 3 different bots. and getting the below error in two bots for reading same file. External Table is not in the expected format strange thing is, one bot is throwing the error while reading the sheet1 and another have read...
  8. B

    External Table is not in the expected format ...Error while using OLEDB in Blue prism

    Hi Experts, I am using OLEDB in my process and running the process in 3 different bots. and getting the below error in two bots for reading same file. External Table is not in the expected format strange thing is, one bot is throwing the error while reading the sheet1 and another have read...
  9. 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