Sparky Fluff
New member
- Local time
- Today, 17:47
- Joined
- Jul 12, 2007
- Messages
- 1
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 the PolicyTemp table depending on the values of other fields that have been imported. Can someone help me do it?
Thanks.
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 the PolicyTemp table depending on the values of other fields that have been imported. Can someone help me do it?
Thanks.