如何将 ms excel 2003 链接到 ms access 2003
我有 Office 2003，并且我已经从 MS Access 2003 开发了一个数据库。 我想要的是链接 ms excel 和 ms access，以便在更新时它们都会更新
I have office 2003, and i have develop a database from ms access 2003.
What i want is to link ms excel and ms access so as when am updating either of them both will be updated
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我知道在 Access 中，您可以添加一个以 Excel 工作表作为数据源的“链接表”。这将导致 Excel 工作表中的数据在 Access 中显示为表格。当您在 Access 中更改数据时，基础 Excel 工作表中的数据将会更改。此外，如果您打开 Excel 工作表并更改其中一行中的值，则刷新 Access 中的链接时将反映更改。
但是，尝试将 Access 和 Excel 链接在一起时可能会出现问题。您可能无法同时从 Access 和 Excel 编辑同一文档。此外，如果您向 Excel 中的源数据添加其他列或行，则可能必须完全重新链接 Access 中的表。
如果您是 Access 应用程序和 Excel 工作表的唯一用户，则可以使用此方法开发相当强大的解决方案。但是，尝试为多个用户部署这样的解决方案时必须小心，因为当多个人同时尝试编辑同一文档时，您可能会遇到问题。此时，您可能需要考虑涉及数据库或 SharePoint 后端的更强大的解决方案。
I know that from within Access, you can add a "linked table" with an Excel worksheet as a data source. This will cause the data in the Excel sheet to show up as a table in Access. When you make changes to the data in Access, the data in the underlying Excel sheet will change. Also, if you open up the Excel sheet and change the values in one of the rows, the change will be reflected when the link in Access is refreshed.
However, there can be issues when trying to link Access and Excel together. You may not be able to edit the same document from Access and Excel at the same time. Also, if you add additional columns or rows to your source data in Excel, you may have to completely re-link the table in Access.
If you are the only user of both the Access application and Excel sheet, you can develop a fairly robust solution using this method. However, you have to be careful with trying to deploy a solution like this with multiple users because you may start to get issues with multiple people trying to edit the same document at one time. At this point, you may need to look at more robust solutions involving a database or SharePoint backend.
正如本在他的回答中所说，这是可能的，但很容易在多用户环境中导致问题。我建议保留数据的访问权限并从 Excel 中提取数据。或者重新访问是否需要 Excel 来更新日期（只读报告就可以了）
As Ben said in his answer it is possible but can easily lead to problems in a multi user environment. I would suggest keeping the data in access and pulling it from excel. Or revisiting if excel is needed at all to update the date (read only reports would be ok)