I have a rather odd problem. I am importing an Excel into an Access database and then updating 2 tables from it's data. I'm doing it by using a series of DoCmd.RunSQL statements as shown below:
Dim msgboxResponse
Dim strSQL As String
msgboxResponse = MsgBox("Are you sure you want to update...