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.
我正在使用VBA和访问excel，我需要我的系统将其数据保存到Access数据库，并且每当添加，删除或修改任何新记录时，数据库都应该更新。
I would like to link my spreadsheet and database using ADO but i couldn't find any online resources to help me with that.
我想使用ADO链接我的电子表格和数据库，但我找不到任何在线资源来帮助我。
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
谢谢安德鲁
1 个解决方案
#1
2
I am surprised you are having difficulty finding on-line resources. The topic comes up on * often enough, for example: Export value from Excel worksheet to Access record
我很惊讶你在寻找在线资源方面遇到困难。 *上的主题经常出现，例如：将Excel工作表中的值导出到Access记录
#1
2
I am surprised you are having difficulty finding on-line resources. The topic comes up on * often enough, for example: Export value from Excel worksheet to Access record
我很惊讶你在寻找在线资源方面遇到困难。 *上的主题经常出现，例如：将Excel工作表中的值导出到Access记录