Importing XML Data

You can use the Access built-in Import command to import an XML data or XML schema document to a database. When you import structure or data from an XML file, Access assigns the Text data type to all the fields in a table. However, when you import structure from an XSD schema file, each field is assigned a data type that closely matches the data type specified in the schema. You can change the data types after importing data or a table structure as long as the fields' data allows such a change.

When you import a schema, Access creates a new empty table with the structure of the imported schema. Earlier in this chapter, when you exported the Shippers table to XML format, Access also created the schema of that table. Hands-On 29-7 shows how to import this schema document to a new Access database.

Part V

0 0

Post a comment