将XML导入Access时出现问题 [英] Problem with importing XML into Access

问题描述

我首先创建了PDF表单，该表单有助于收集用户的数据.通过接收来自用户的数据，我们获得了xml文件.

我遇到的问题是将XML文件导入Access 2007数据库.当我这样做时，它会创建很多我无法控制结构的表.

最大的问题是每个表的主键/外键.只有一个包含主键(课程代码)的表是Page 1表，其他表都没有该表.因此，我无法创建关系或执行查询.您知道如何将键填充到其他表吗?请帮帮我！

这是所有文件 http://www.megaupload.com/?d=AS08DHA0

问候，
Lam

I first created the PDF form which helps collect data from users. By receiving the data from users, we have xml files.

The problem I got is to import the XML file into Access 2007 database. As I do that, it creates a lot of tables that I can''t control the structure.

The biggest problem is the primary/ foreign keys of each table. There is only one table contain primary key (Course Code) that is Page 1 table, none of other tables have the table. Therefore I cannot create relationships or do queries. Do you know how to populate the key to other tables? Please help me out!

Here are all the files http://www.megaupload.com/?d=AS08DHA0

Regards,
Lam

推荐答案

http://www.databasedev.co. uk/access2007_import_xml.html [ ^ ]

http://www.databasejournal.com/features/msaccess/article.php/3310901/Import-XML-Data-Into-Microsoft-Access.htm [ http://technet.microsoft.com/en-us/library/ee692914.aspx [ ^ ]

http://office.microsoft.com/zh-cn/access-help/import-or-link-data-and-objects-HP005187610.aspx [

http://www.databasedev.co.uk/access2007_import_xml.html[^]

http://www.databasejournal.com/features/msaccess/article.php/3310901/Import-XML-Data-Into-Microsoft-Access.htm[^]

http://technet.microsoft.com/en-us/library/ee692914.aspx[^]

http://office.microsoft.com/en-us/access-help/import-or-link-data-and-objects-HP005187610.aspx[^]

这篇关于将XML导入Access时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！