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

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 16:17:35  来源:igfitidea点击:

DoCmd.RunSavedImportExport not working

ms-accessvbaaccess-vba

提问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.

问题是它不会让我使用删除并重新创建表的已保存导入。我不得不创建一个导入到现有表中的新表。