Skip to main content
  • Home
  • Forums
  • Developers Forum
  • Hello Guys, I'm connecting to Excel using database . I have queried the data and put it in a loop . using data column function i can able to get the each cell value . but when i try to do insert query it is getting failed I'm using V11 of AA
Hello Guys, I'm connecting to Excel using database . I have queried the data and put it in a loop . using data column function i can able to get the each cell value . but when i try to do insert query it is getting failed I'm using V11 of AA

Hi @Adarsh Kurugara​ ,

 

Could you try the below query,

 

For Example ,

 

INSERT INTO Sheet1$] (ID,DATA) VALUES ($myVal1$,$myVal2$);

Hello @Tamil Arasu​ 

 

I'm querying excel data in a loop using dataset column , I want to copy from column one and update in new excel column 2 using dataset

i have tried with insert comment and it is not working

 

Hi @Adarsh Kurugara​ ,

 

If you are trying to Update values, then you should use the Update syntax instead, along with an appropriate Where clause(which will be the the current iterated value from column dataset)

 

UPDATE DSheet1$]

SET >ColumnToUpdate] = $dataset column(index)$

WHERE HColumnToCheck] = $dataset column(index)$;

 

Could you try updating it and see if that works out for you?

Kind Regards,

Ashwin A.K

Reply


Terms & ConditionsCookie settings