Hi,
I am using the following code to import excel spreadsheet into Access
Private Sub Cmd_Import_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, _
"PolicyTemp", "U:\QA\Sample_Input.xls", True, "Sheet1!"
End Sub
After the import, I need to update certain fields in...