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...
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...
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.
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...
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
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...
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...
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 ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.