[ADOSQL][VBA] Update information instead of inserting

[alexgoaga]

Hey Guys,

I have a problem regarding modifying the code below instead of inserting new data into an .mdb access file to update the specific row where "ID" = something
I've tried several times with different types of update codes but it keeps giving me errors even for the simplest update functions such as

Note : the website firewall blocks me from posting sql commands?
https://stackoverflow.com/questions/...sing-variables

If necessary i will upload / attach an .mbd file and a excel file with the specific problem

Does somebody know where i should re-build the code?

Explications of the code below:
2 Ranges of date on 2 separate rows
The first rows contains the table_columns name and the second one, the values to be updated.

The 2 rows are prepared then inserted into the specific database.

Note : the website firewall blocks me from posting sql commands attached file .txt?

[Norie]

Do you have an example Excel workbook?

Any chance you could upload it?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[alexgoaga]

managed to update and come with a viable DB example and workbook

[Norie]

Can't have a proper look right now but can I ask you something?

In the code you refer to db_name?

Is that actually the name of the table you want to work with rather than the database?

[alexgoaga]

db_name stands for the name of the table found in the .mdb access file.

[alexgoaga]

Hey guys, I managed to create a perfect way to add the data to my database, attached file with the solved code