将Excel数据导入数据库中的多个表 [英] Import Excel data to multiple tables in a database

问题描述

hi

我是使用MS access 2013的新手。我创建了两个多表有关系。一个表用于输入公司详细信息，一个表用于同一公司的联系详细信息。现在两个表都是链接的。

但我希望导入包含公司名称和联系方式的excel表格数据。

一个公司记录可以有多个联系人详细信息。请告知我如何将Excel工作表导入多个表格。

解决方案

嗨sdcisa，

感谢您访问我们的论坛。

然后，此论坛主要关注与Office客户端相关的一般问题和反馈。由于您的查询是关于将数据导入Access，因此我将您的主题移至以下专用的MSDN论坛以获得更好的响应：

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

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

最好的问候，

Yuki Sun

hi

I am newbie in using MS access 2013. I have created two Multiple tables with relationship. One table is for entering company details and one table is for contact details in that same company. now both tables are linked.

but i wish to import excel sheet data containing company name and contact details.

One company record can have multiple contact details. Please advice how i can import the excel sheet to multiple tables.

解决方案

Hi sdcisa,

Thanks for visiting our forum.

Then this forum mainly focus on general questions and feedback related to Office client. Since your query is about importing data to Access, I'll move your thread to the following dedicated MSDN forum for Access for better response:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

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.

Best regards,
Yuki Sun

这篇关于将Excel数据导入数据库中的多个表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！