Passing variables to an Update Sql Statement in VBA/Excdel
-
I hope I posted in the correct forum, as I did not see a VBA forum. My apologies if not. I am needing to solve a problem for a couple of coworkers. They have a workbook where several sheets are being utilized. The first sheet is a form, the second keeps track of each time the form is filled out. To keep the original form, I was planning on having a database to hold the information on the second sheet that both offices could have access. The problem is that I have never passed parameters to a sql statement in VBA and never wrote to a database with an UPDATE statement in VBA. I've googled a bit about the subject but did not get any relevant results. So I came here, hoping someone would have some experience with this. Any help is appreciated.
Jude