Excel - VBA - 将数据保存到 Access 数据库
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4179513/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel - VBA - Save Data to Access Database
提问by Andrew1962
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 和 access 处理 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
谢谢安德鲁
采纳答案by Fionnuala
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
我很惊讶您很难找到在线资源。这个话题经常出现在 Stackoverflow 上，例如：Export value from Excel worksheet to Access record
