4

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

Improve this question

1 Answer 1

Reset to default
2

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.