AndrewKent
11-19-2008, 02:37 AM
Hi there,
I am currently building a program in Excel whereby I can send data to and from an Access Database. I have copied in a segment of code that I use to update one table in the database...
Set DBRecordSet = New ADODB.Recordset
DBRecordSet.CursorLocation = adUseServer
DBRecordSet.Open Source:="StaffData", ActiveConnection:=DBConnection, CursorType:=adOpenDynamic, LockType:=adLockOptimistic, Options:=adCmdTable
...however I want to modify this so it updates not just "StaffData" but "CustomerData" as well. How would I do this?
Andy
I am currently building a program in Excel whereby I can send data to and from an Access Database. I have copied in a segment of code that I use to update one table in the database...
Set DBRecordSet = New ADODB.Recordset
DBRecordSet.CursorLocation = adUseServer
DBRecordSet.Open Source:="StaffData", ActiveConnection:=DBConnection, CursorType:=adOpenDynamic, LockType:=adLockOptimistic, Options:=adCmdTable
...however I want to modify this so it updates not just "StaffData" but "CustomerData" as well. How would I do this?
Andy