问题描述
来自业余新手的第一篇文章......
已将此代码放在一起，以便将数据从Excel电子表格上传到Access后端。从一个电子表格中，数据正确输入，但是从另一个稍微适应的数据，数据不会出现。我可以看到链接几乎正在制作，因为我的PK自动编号正在递增，留下失败的插入引起的间隙。使用了debug.print我想知道前导/尾随空间是否搞乱了所以我使用了Trim，但仍然没有快乐。
这是代码 - 感谢去年ZMDB发布的帖子这个的基础。
First post from an amateur newbie......
Have put this code together to upload data from an Excel spreadsheet into an Access backend. From one spreadsheet the data enters correctly, but from another which is slightly adapted, the data does not appear. I can see that the link is almost being made, as my PK autonumbers are incrementing leaving gaps the failed inserts are causing. Having used a debug.print I wondered if leading/trailing spaces were messing things up so I used Trim, but still no joy.
Here is the code - thanks to a post last year from ZMDB for the basis of this.
这篇关于Excel to Access，SQL和VBA的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！