How to Delete records (Access/Excel)

[elbatz]

Hi! Does anyone know the code of how to delete records in access using excel as reference.
example:

Delete * FROM table1 WHERE table1.ID=excel file.ID ?

Thanks

[vksingh24]

Hi! Does anyone know the code of how to delete records in access using excel as reference.
example:

Delete * FROM table1 WHERE table1.ID=excel file.ID ?

Thanks

1) Create a Link Table in your ms-access database of the EXCEL File
2) Create a Query

DELETE * FROM table1 where table1.[ID] IN (SELECT [ID] FROM ExcelFile);