多个excel导入mysql数据库,将Excel数据导入数据库中的多个表

最新推荐文章于 2023-05-04 16:44:30 发布

weixin_39756273

最新推荐文章于 2023-05-04 16:44:30 发布

阅读量243

点赞数

文章标签：多个excel导入mysql数据库

用户在MS Access 2013中创建了两个相关联的表，一个用于公司详情，另一个用于同一公司的联系人详情。现在他们希望从包含公司名称和联系人详细信息的Excel表格导入数据。由于一条公司记录可能有多个联系人详情，所以需要知道如何将Excel数据正确地导入到这两个关联的表中。

摘要由CSDN通过智能技术生成

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:

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