需要帮助将多个Excel备份标签导入一个访问表 [英] Need help importing multiple excel tabs into one Access Table

问题描述

我有一个包含20多个标签的excel文件。我需要将所有选项卡导入到一个表中，并且无法找到执行此操作的代码。我希望用户能够按下按钮，导航到excel文件并有权访问所有选项卡。任何人都可以帮助或遇到类似的问题吗？

解决方案

我有一个包含超过20个标签的excel文件。我需要将所有选项卡导入到一个表中，并且无法找到执行此操作的代码。我希望用户能够按下按钮，导航到excel文件并有权访问所有选项卡。任何人都可以帮助或遇到类似的问题吗？

当你说多个标签时你的意思是多张标签。工作表名称是什么？

当您说多个选项卡时，您的意思是多个工作表。工作表名称是什么？

工作表名称有所不同。用户正在使用日期。工作表名称通常是05-01; 05-02; 05-03; 05-04; 05-07等


每张纸都是每天添加的，我需要能够自动导入所有纸张或者让用户选择要导入的纸张。 / blockquote>

你在这里谈论的是非常复杂的自动化代码。不幸的是，我没有时间引导你完成它。看看这个教程，我会看看我是否可以找人帮助你。

应用程序自动化


Mary

I have an excel file that has over 20 tabs. I need to import all tabs into one table and am having trouble finding code to do this. I would liike the user to be able to press on button, navigate to the excel file and have access import all tabs. Can anyone help or run across a similiar problem?

解决方案

I have an excel file that has over 20 tabs. I need to import all tabs into one table and am having trouble finding code to do this. I would liike the user to be able to press on button, navigate to the excel file and have access import all tabs. Can anyone help or run across a similiar problem?

When you say multiple tabs do you mean multiple sheets. What are the sheet names?

When you say multiple tabs do you mean multiple sheets. What are the sheet names?

The sheet names vary. The user is using dates. Sheet names are usually 05-01; 05-02; 05-03; 05-04; 05-07, etc.

Each sheet is added on a daily basis and I need to be able to automate importing all sheets or have the user pick the sheet they want to import.

What you are talking about here is very complicated Automation code. Unfortunately, I don''t have the time to guide you through it. Have a look at this tutorial and I''ll see if I can get someone to help you out.

Application Automation

Mary

这篇关于需要帮助将多个Excel备份标签导入一个访问表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！