Share this Page URL

Chapter 16. Working with XML Data in Acc... > Importing an XML Document into Acces... - Pg. 572

Working with XML Data in Access 572 Transforming Your XML You might also have noticed that when you clicked the Options button, a Transform button appeared. Transforms have to do with presentational layout as well as data manipulation. We'll cover transforms in the section "Presenting XML Data with Access," later in this chapter. Access allows you to apply a transform to your data as you import it so that you don't have to run extra processes on the data after it is in an Access table. 7. Because we want to import both the structure and the data, leave the default selection, and click the OK button. Access informs you that the import was successful, that it created a new table named Table1, and that it populated your table with the data in the XML document. You might be wondering how Access knew what constraints to put on the data, which field to make the primary key, and what data types to make each field. If you open the table in Design view, you'll notice that Access imported all the fields as text fields, did not create a primary key, and did not index any of the fields, as shown in the following illustration.