vba DoCmd.RunSavedImportExport 不起作用
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/10758211/
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
DoCmd.RunSavedImportExport not working
提问by Ken
I don't understand if I run the saved import manually it works but when it is in the vba code is it just doesn't. When I step through it stops as if to run it but it never does anything and it just moves on.
我不明白我是否手动运行保存的导入它可以工作,但是当它在 vba 代码中时它就没有。当我通过它时会停下来,好像要运行它,但它从不做任何事情,它只是继续前进。
DoCmd.RunSavedImportExport "Import-DES_INV_TSR_ACIPS_FINAL"
DoCmd.RunSavedImportExport "Import-DES_INV_TSR_ACIPS_FINAL"
Any help please.
请任何帮助。
采纳答案by Ken
The problem is that it would not let me use a saved import that deleted and recreated the table. I had to create a new one that imported into an existing table.
问题是它不会让我使用删除并重新创建表的已保存导入。我不得不创建一个导入到现有表中的新表。