问题描述
我首先创建了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
推荐答案
这篇关于将XML导入Access时出现问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！