XML . Access, ? : XML . , , , , , XML. Access , ACCDB- XML-.
, XML Access . , Access XML-. , . . 19.11. ( XML- .)
. 19.11. , XML-
, Access XML-, :
<dataroot>
<Product>
<ProductID>371</ProductID>
<Name>Thin-Jam Hex Nut 7</Name>
<ProductNumber>HJ-7161</ProductNumber>
<SafetyStockLevel>1000</SafetyStockLevel>
<ReorderPoint>750</ReorderPoint> </Product> <Product>
<ProductID>372</ProductID>
<Name>Thin-Jam Hex Nut 8</Name>
<ProductNumber>HJ-7162</ProductNumber>
<SafetyStockLevel>1000</SafetyStockLevel>
<ReorderPoint>750</ReorderPoint>
</Product>
Access :
■ <dataroot>;
■ Access , . , <Product> ;
■ Access .
<Name>, <ProductNumber> . .
XML- . , , , XML- . , , <ProductRecords>, <dataroot> . , , XML-.
, . XML- Access, , , XML- , . XML- Access , .
|
|
, . , , ( ).
, XML-. Access XML- . XML- , .
XML-
, XML , Access, . .
1. → → → XML- (External Data → Export → More → XML File).
.
2. , , .
Access , . , Orders, XML- rders.xml.
3. , (. 19.12):
□ (XML) (Data (XML)) XML- ;
□ (XSD) (Schema (XSD)) xsd. , , . , , XML- Access, Access;
□
(XSL) (Presentation (XSL)) xsl. , XML- Web- HTML, Web-. , Access htm-, xsl-. , Products, Web- Products.htm. Web-, Products.xsl Products.xml.
. 19.12. XML-, . ,
4. XML-, ... (More Options...).
XML (Export XML) . XML. (Data) (. 19.13).
, Orders .
|
|
□ . OrderDetails . Access XML- OrderDetails Orders.
□ . , , OrderStatus CreditCards. [ ] ([Lookup Data]), , ( , ).
. 19.13. , . , ,
, XML-, (, ). .
5. .
Access , 3.
6. , (Save export steps).
(Close) Access.
XML-
Access XML-, , . . .
1. → → XML- (External Data → Import → XML File).
.
2. , , . , , , 6.
XML-, , , . , .
3. .
Access , (. 19.14).
. 19.14. Access , Orders, OrderDetails, OrderStatus CreditCards.
4. .
Access . .
, Access , (, Products1, Products2 . .).
5. (Close), Access.
6. → → XML- (External Data → Import → XML File).
, , .
7. XML-, , , .
Access XML- , , .
8. .
|
|
o (Append Data to Existing Table(s)) Access . , .
o (Structure and Data) .
o (Structure Only) , .
, ( 15), .
9. .
Access XML-.
, (Save export steps).