Can anyone help me edit the following code so that I can use an excel row to edit an access database. The code is to be put in a Macro and used via command button on excel worksheet.
Dim dbMyDB As Database
Set dbMyDB = OpenDatabase(“C:\Pro.mdb”)
Dim rsMyRS As Recordset
Set rsMyRS = dbMyDB.OpenRecordset(“Customers”, dbOpenDynaset)
rsMyRS.Edit
rsMyRS!Name = Range(10, 1)’ here is the prob
rsMyRS.Update
