Hi All,
I have a database which imports training records in the form of an Excel sheet into a table in Access. My problem is that it's only importing unique records, even though an employee may have 10 different training records, it will only import one of them ?. I'm using the VB code below in the OnClick event of a command button to handle the importing of the records from Excel. Any help would be very much appreciated. Thanks Em
Code:
Private Sub cmdWrappers_Click()With DoCmd
.SetWarnings False
.OpenQuery "qry_DeleteWrappingEnd"
.TransferSpreadsheet acImport, 10, "tbl_WrappingEndRecords", "S:\WrappingEndTrainingRecords.xlsx", True, ""
MsgBox "Wrapping End Training Records Imported !", vbInformation + vbOKOnly, "Database Update Successful !"
.SetWarnings True
End With
End Sub]