如何从Access更新Excel中的库存？ [英] How to update Stock in Excel from Access?
问题描述
我在MS Access 2007中创建一个报价数据库，为印刷公司准备报价。
我有2个表，tblClient和tblQuote与1对多关系。
在报价表格中，我有一个名为BusinessCards的基板。
当客户要求500时名片，用户单击复选框并计算值。
我用几行VBA代码实现了这一点，但与此同时，我希望用户通知有关基板的可用性，以便完成工作。
all股票（基板）信息在Excel电子表格中（C：/Stock/StockSheet.xls）。例如，名片的可用库存位于电子表格的单元格R10中。我想在准备报价时访问此单元格以检查库存的可用性。
是否可以从Access访问Excel中的特定单元格？
如果有，有人可以告诉我该怎么做吗？！
谢谢和问候，
Asle
Hi,
I am creating a Quote Database in MS Access 2007 that prepares Quote for a Printing Company.
I have 2 tables, tblClient and tblQuote with 1-to-many relationships.
in the Quote form, i have a substrate called BusinessCards.
when customer request for 500 Business cards, the user Clicks the checkbox and it calculates the value.
I have acheived this with few lines of VBA code but at the same time, i want the user to notify about the availability of substrate to preform the jobs.
all Stock (substrate) information are in Excel spreadsheet (C:/Stock/StockSheet.xls). for example, the available stock for business cards is in cell R10 of the spreadsheet. i want to access this cell to check for availability of stock while preparing the Quote.
Is it possible to access a particular cell in Excel from Access ?
if yes, could anyone tell me how to do this, please?!
thanks and regards,
Asle
推荐答案
我在MS Access 2007中创建报价数据库，准备报价对于一家印刷公司。
我有2个表，tblClient和tblQuote与1对多的关系。
在报价表格中，我有一个名为BusinessCards的基板。
当客户要求500张名片时，用户点击复选框并计算价值。
我用几行VBA代码实现了这一点，但与此同时，我希望用户通知有关基板的可用性，以便完成工作。
all股票（基板）信息在Excel电子表格中（C：/Stock/StockSheet.xls）。例如，名片的可用库存位于电子表格的单元格R10中。我想在准备报价时访问此单元格以检查库存的可用性。
是否可以从Access访问Excel中的特定单元格？
如果有，有人可以告诉我该怎么做吗？！
谢谢和问候，
Asle
Hi,
I am creating a Quote Database in MS Access 2007 that prepares Quote for a Printing Company.
I have 2 tables, tblClient and tblQuote with 1-to-many relationships.
in the Quote form, i have a substrate called BusinessCards.
when customer request for 500 Business cards, the user Clicks the checkbox and it calculates the value.
I have acheived this with few lines of VBA code but at the same time, i want the user to notify about the availability of substrate to preform the jobs.
all Stock (substrate) information are in Excel spreadsheet (C:/Stock/StockSheet.xls). for example, the available stock for business cards is in cell R10 of the spreadsheet. i want to access this cell to check for availability of stock while preparing the Quote.
Is it possible to access a particular cell in Excel from Access ?
if yes, could anyone tell me how to do this, please?!
thanks and regards,
Asle
简单的方法是链接到电子表格
（File..Get external data..Link（note NOT import）。...类型下拉列表中的文件选择文件的Excel version.browse单击确定，电子表格将附加到Access中的表格界面。然后，您可以在链接上运行查询和查找功能。表，好像它实际存在 IN 您的访问数据库
问候
Jim
The simple way is to LINK to the spreadsheet
(File..Get external data..Link (note NOT import) . ...files of Type dropdown select the Excel version.browse for the file click ok and the spreadsheet will be attached to the tables interface in Access. You can then run queries and lookup functions across that ''Linked'' table as though it were physically present IN your access database
Regards
Jim
查看应用程序自动化。
让我们知道你是怎么做的：）
Check out Application Automation.
Let us know how you get on :)
查看应用程序自动化。
告诉我们你是怎么上的:)
Check out Application Automation.
Let us know how you get on :)
大家好，
我将excel表链接到访问数据库并包含一些基本的VBA代码..
它的工作非常好...感谢您的快速回复。
Neopa，我看了你问我的帖子......我想我会尝试在后期使用outlook autmation ......它看起来比我想象的要简单得多。谢谢你的搭档..
chuz，
Asle
Hi guys,
I linked the excel sheet into the access database and included some basic VBA code..
its working really good... thanks a ton for your speedy reply.
Neopa, i looked at the post you asked me to ... i think i will try to use the outlook autmation at the later stage... it looks much simpler than i thought. thanks mate..
chuz,
Asle
这篇关于如何从Access更新Excel中的库存？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
