阅读背景:

如何使用VBA清除Access中的表?

来源:互联网 

What I'm trying to do is, while in Excel, use VBA to push data to an existing Access table. I've been able to do this, but am having one small hiccup. Before I push the data to access, I want to clear the current data on the Access table, so when the new data from Excel comes in, it is the only data in the Access table. I really don't know how to write code for Access since the class has been on VBA for Excel. I've tried several different approaches and each time it doesn't work. For example, the code that seemed like it should work isWhat I'm trying to do is, while in Excel, use V




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: