Excel - VBA - 将数据保存到Access数据库

时间:2021-05-01 15:37:27

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记录