Skip to main content
Question

Update Query not working properly


mandarB
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • 17 replies

Hi , Im using Update query in excel as Database Command . The query runs for some iterations and then fails. The same query works in other sheet. Here im trying to match items from both vlookups. There are two sheets where im applying query in workbook. The update query:

 

 

3 replies

mandarB
Forum|alt.badge.img+9
  • Author
  • Navigator | Tier 3
  • 17 replies
  • June 26, 2024

It is working fine. Thanks


HemanthaPindra
Forum|alt.badge.img+5

Hi mandarB,

 

As you mentioned it is failing in one sheet and running for some iterations. Please check exactly in which row it is failing by using counter and confirm that whether it is failing always in the same iteration or different. If it is same iteration, then check that row data.

 

Please let us know.

 

Thanks,

Hemantha Pindra

 


HemanthaPindra
Forum|alt.badge.img+5

mandarB,

It would be great if you share the solution. May be helpful to someone.

 

Thanks,

Hemantha Pindra

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings