问题描述
我有一个从中搜索我的数据库，查看存储中有多少个打印机墨盒，订购了多少个，以及订购的日期。我需要帮助的是，每当用户说他们订购了一个墨盒中的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.
这篇关于一起使用Access和Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！