Click here to Skip to main content
15,868,016 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
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
Posted
Updated 31-May-11 11:40am
v2

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900