Update Access from Excel
I'm new to this forum and i want some help from the members of this forum.
i've an excel sheet which holds a large no of columns which i've been able to connect with Access database (data structure for both are same).I'm using Excel as front end to capture customer requirements and want the same to be updated in my access database.
Can anyone help me, how i can achieve this so as to make my Database updated whenever i update or delete records from Excel.
Thanks in advance,