Access to xml file
I have to do:
Make table from query.Table(id,barcode,name,quantity,price).
Each account has a separate file(database) which consists of:vendor name, invoice number, invoice date.Name of table is ImportAccessFile.That table look like this,but how make each database and that has invoice number,invoice date:
<?xml version="1.0" encoding="UTF-8" ?>
- <dataroot xmlns:od="urn:schemas-microsoft-com:officedata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ImportAccessFile.xs d" generated="2012-02-16T13:09:38">
- <ImportAccessFile>
<ID>2</ID>
<barcod>8600133231641</barcod>
<naziv>LV SOK 0,2L CR.KOKTEL BRIK</naziv>
<kolicina>24</kolicina>
<fakcij>0.33</fakcij>
<rabat>7</rabat>
</ImportAccessFile>
</dataroot>
|