如何通过vba单击一个buttone将Ms Excel数据范围导出到Ms Access特定表 [英] How to export Ms Excel data range to Ms Access specific Table by vba clicking in a buttone

问题描述

Hello亲爱的所有人，我有一张excel表，想要将特定范围导出到ms访问表。有没有办法通过单击VBA按钮导出它？

Hello Dear All, I have a excel sheet and wanna export specific range to a ms access table. Is there is any way to export it by clicking a button of VBA?

提前致谢... !!!

Thanks in advance...!!!

推荐答案

Hello亲爱的所有人，我有一张excel表，想要将特定范围导出到ms访问表。有没有办法通过单击VBA按钮导出它？

Hello Dear All, I have a excel sheet and wanna export specific range to a ms access table. Is there is any way to export it by clicking a button of VBA?

提前致谢... !!!

Thanks in advance...!!!

你好，

有很多关于如何实现这一目标的例子，但是下面的链接是使用ADO来完成这个：

There are numerous examples on how to accomplish this, but below link is using ADO to accomplish this:

将Excel范围导出到Access

希望这有帮助，

这篇关于如何通过vba单击一个buttone将Ms Excel数据范围导出到Ms Access特定表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！