Importing XML schema and table relationships

L

lbusboom

I am trying to import an XML schema into Access 2003.
When I do so, the tables are correctly defined, but the
relationship of parent table to child tables is not
imported. This means that I have to manually re-
establish the table relationship within Access. I want
to be able to import the tables (from an XML Schema and
data file) and have the relationships established
automatically. Can I do this? If so, how?
 
J

Joe Fallon

Nope.
You have to pre-define the relationships, empty the tables and then import
the data.
The *existing* relationships should still be there.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XML DTDs Versus XML Schema 0
Import of XML schema (XSD) crashes MS Access 0
import xml not a problem, setting key for subtables is 1
Question on importing xml to Access 1
Importing XML Data in Access 2003 1
Specification XML failed to validate against the schema 1
Problems Importing Govt. XML Files 1
Create XML file from Access using predefined schema 3

Top