一起使用Access和Excel [英] Using Access and Excel together
问题描述
我有一个从中搜索我的数据库，查看存储中有多少个打印机墨盒，订购了多少个，以及订购的日期。我需要帮助的是，每当用户说他们订购了一个墨盒中的5个我需要该数字进入Excel电子表格，并让电子表格重新计算总数，因此我可以跟踪当年使用的数量。这甚至是可能的，我只是不知道如何做到这一点。
I have a from that searches my database to see how many printer cartridges there are in storage, how many were ordered, and what date they were ordered. What I need help with is whenever a user says they ordered 5 of one cartridge I need that number to go into an Excel spreadsheet, and have the spreadsheet recalculate the total, so I can keep track of how many were used that year. Is this even possible, I just have no clue about how to do it.
推荐答案
我有一个来自那个搜索我的数据库，查看存储中有多少个打印机墨盒，订购了多少个，以及订购的日期。我需要帮助的是，每当用户说他们订购了一个墨盒中的5个我需要该数字进入Excel电子表格，并让电子表格重新计算总数，因此我可以跟踪当年使用的数量。这甚至可能，我不知道如何做到这一点。
I have a from that searches my database to see how many printer cartridges there are in storage, how many were ordered, and what date they were ordered. What I need help with is whenever a user says they ordered 5 of one cartridge I need that number to go into an Excel spreadsheet, and have the spreadsheet recalculate the total, so I can keep track of how many were used that year. Is this even possible, I just have no clue about how to do it.
这将涉及一个名为OLE Automation的过程 - 我会在最方便的时候给你答案。
This will involve a process called OLE Automation - I will have an answer for you at my earliest convenience.
好的谢谢那会很棒。
我确实找到了这个：
Ok thanks, that would be great.
I did find this:
它必须是excel吗？你可以把它保存在Access中。
Does it have to be excel? You could very well just keep it in Access.
这篇关于一起使用Access和Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
