I'm working on excel with VBA and access and i need my system to save its data to an Access database and whenever any new records added, deleted or modified the database should update.
I would like to link my spreadsheet and database using ADO but i couldn't find any online resources to help me with that.
Can you please let me know what i need to now in order to do that and any link that you may know that will be usefull?
Thank you Andrew
