将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屋!