Question

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

  • 18 February 2022
  • 3 replies
  • 35 views

Badge +4
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

3 replies

Userlevel 5
Badge +10

Hi @Adarsh Kurugara​ ,

 

Could you try the below query,

 

For Example ,

 

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

Badge +4

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

 

Userlevel 4
Badge +7

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 [Sheet1$]

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

WHERE [ColumnToCheck] = $dataset column(index)$;

 

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

Kind Regards,

Ashwin A.K

Reply