Hi I am importing data from excel and it works fine here is code I am using to import.

Private Sub Command9_Click()
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel11, _
"myTable", "C:\Users\XPS\Desktop\AccessDB\Book1.xls", True

End Sub

but when the button is click again then data from the Book1.xls is imported again as new Entry. So is it possible to stop import one its done or import only if new data is found in Book1.xls

Thank you