Update SQL using Excel VBA

This is the 2nd part of the Connect to SQL video, now that we have connected the SQL customer table to Excel we now want to be able to update the records using Excel and have them automatically update in SQL.

Please like and leave a comment if you find this useful and subscribe.

Enjoy
MM

[lleonsands]

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

[bentlauridsen]

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

[leegarrett]

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

[makali]

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

[patrikrosen]

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?

[ekremacar]

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

[pratikt]

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

[rv]

ID Must be the primary key and Auto Increment.

[muhammadasrul]

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

[makali]

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

[petermaina]

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

[danielbalcer]

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 ;-)