Update SQL using Excel VBA

Can you please update this video again because there is some issue which i am facing for target.row i have tried many time but it is not working

i was finding this way from last 3 weeks
day night R&D

best but i will apply it in morning in my office

hope this will work

Great vdieo. Can you please share the code of maybe the excel?

Can I use the Command button for the worksheet change event? I don't want to trigger the Worksheet_change event automatically.

Brilliant, thank you! You just made me look like a rock star!

What if my row is number such as 2020 as a row . How de we declare in the VBA statement ?

Can I have the source code please

Great videos. Is it possible to get the vba code? To download it. Both for this and the other videos you did?
Or can you share the excel file?

ID Must be the primary key and Auto Increment.

THE MISMATCH ERROR IS BECAUSE OF MISSING ' ' ON ID TO INDICATE BLANK

Really good tutorial but why have you not used an excel table(list object)?

Please share the code. Thanks

Great video! can you share the code?

Hi, could you share your code on webpage or google drive? It looks like a solution to my problem, but analyzing the code based on the video is ...difficult ;-)

The reason for your problem with the if statement onID are that ID is declered as Integer therefore the line should be "If ID = 0 Then" , and the reason that it works on Age is because you didn't write as integer after AFE is has been decleared as Variant