Search results

  1. S

    Import XL and Update fields

    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...
Back
Top Bottom