I have the following code which executes a saved import.
Private Sub cmdImportData_Click()
If MsgBox("This function will import the named range of your Excel file and append the data table. You must be sure to do this only one time for each new Excel file. Do you wish to continue??", vbYesNo + vbQuestion + vbDefaultButton2) = vbYes Then
MsgBox "The data from the Excel file has successfully been imported."
But if a record, or row in the Excel file, containing for example "5/8/2011" in a field named "Week starting date" in the Excel file and in the resulting Access table already exists I do not want that record to be imported.
How can I do this?