I have users writing info into a sheet in excel and when clicking on the save button, I want to update an access db with that information. Is there a way I can open a db, write an sql to update that info and close the db from the excel save button?
Here is what I have so far, but that is imcomplete
Dim MyCon As New Connection
Set rs = New Recordset
rs.Open "Update logcall_table set clientname = range("b1").value where clientname = 'alex'"
I have also found that in Access:
dim db as database
dim qdf as QueryDef
dim strSQL as string