469,950 Members | 2,067 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

How to Delete records (Access/Excel)

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

Delete * FROM table1 WHERE table1.ID=excelfile.ID ?

Thanks
Dec 26 '07 #1
1 1686
Hi! Does anyone know the code of how to delete records in access using excel as reference.
example:

Delete * FROM table1 WHERE table1.ID=excelfile.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);
Dec 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Rudi Ahlers | last post: by
3 posts views Thread by Tim Marshall | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.