如何从Access数据库自动填充excel表单 [英] how to automatically fill an excel form from access database

问题描述

我在excel上有一份工作申请表，其中包括一个单元格"候选代码"。这个代码是在访问数据库中给候选人的数据的，所以我想要做的就是一旦我在excel中输入这个代码，数据库中的数据
就会在正确的位置自动填充excel表单。

I have a job application form on excel which includes in one of its cells "Candidate Code" this code is given to the candidate's data in an access database so what i want to do is once I enter this code in excel the data in database fills the excel form automatically in its right places.

推荐答案

您好，

根据您的描述，您的要求可能需要使用代码来获得结果，我会将您的问题转移到Excel的MSDN论坛

Based on your description your requirement may need to use code to get the result, I'll move your question to the MSDN forum for Excel

https：// social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev

我们建议适当发布的原因是您将获得最合格的受访者和定期阅读论坛的其他合作伙伴可以分享他们的知识，也可以从与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

这篇关于如何从Access数据库自动填充excel表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！