CODEWITHSUNDEEP
ms-accessexceladovba
Andrew1962
Andrew1962

Reputation: 43

Excel - VBA - Save Data to Access Database

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

Upvotes: 4

Views: 7780

Answers (1)

Fionnuala
Fionnuala

Reputation: 91316

I am surprised you are having difficulty finding on-line resources. The topic comes up on Stackoverflow often enough, for example: Export value from Excel worksheet to Access record

Upvotes: 2

Related Questions