Imprimir página | Cerrar ventana

xml a tabla de access

Impreso de: Foro de Access y VBA
Categoría: Access y VBA
Nombre del foro: Access y Otros sistemas
Descripción del foro: Proyectos ADP & Sql Server, Mysql& Access, MSDE
URL: http://www.mvp-access.com/foro/forum_posts.asp?TID=82078
Fecha de impresión: 21/Julio/2019 a las 11:04


Tema: xml a tabla de access
Publicado por: jdotel
Asunto: xml a tabla de access
Fecha de publicación: 02/Septiembre/2016 a las 19:40
Hola a todos,

Necesito su ayuda para ver como puedo hacer subir este archivo de xml a una tabla de access a traves de VBA.

<?xml version="1.0"?>
<transactionSet periodID="2" periodname="DIARIO" longId="2016-07-01" shortId="836" site="00002">
<openedTime>2016-06-30T06:11:58-05:00</openedTime>
<closedTime>2016-07-01T05:50:30-05:00</closedTime>
<startTotals>
<insideSales>3772020.00</insideSales>
<insideGrand>3844871.00</insideGrand>
<outsideSales>0.00</outsideSales>
<outsideGrand>0.00</outsideGrand>
<overallSales>3772020.00</overallSales>
<overallGrand>3844871.00</overallGrand>
</startTotals>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151928</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:12:22-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="PRINTER MESSAGE">30/06 06:11:40...</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151929</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:12:22-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="PRINTER MESSAGE">               ABIERTA TAPA IMP. - EN    
</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151930</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:12:22-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="PRINTER MESSAGE">30/06 06:11:44... 
</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151931</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:12:22-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="PRINTER MESSAGE">               ABIERTA TAPA IMP. - FUERA 
</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="1">14097</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="835" name="DIARIO"></period>
<date>2016-06-30T06:11:58-05:00</date>
<duration>0</duration>
<posNum>1</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="PERIOD CLOSE">   CERRADO   REPORTE DIARIO 
30/06/16                           06:11 
</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="autocollect" recalled="false">
<trHeader>
<termMsgSN type="FINANCIAL" term="9">522156</termMsgSN>
<trTickNum>
<posNum>9</posNum>
<trSeq>92207</trSeq>
</trTickNum>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:14:26-05:00</date>
<duration>0</duration>
</trHeader>
<trValue>
<trTotNoTax>1000.00</trTotNoTax>
<trCurrTot sysid="1" locale="DOLLAR">1000.00</trCurrTot>
</trValue>
<trLines>
<trLine type="autocollect">
<trlTaxes></trlTaxes>
<trlFlags></trlFlags>
<trlDept number="9998" type="fuel">MANUAL FUEL DE</trlDept>
<trlCat number="9999">FUEL DEPOSIT</trlCat>
<trlNetwCode>4</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlUnitPrice>205.700</trlUnitPrice>
<trlLineTot>1000.00</trlLineTot>
<trlFuel type="autocollect">
<trlFuelSeq>1</trlFuelSeq>
<fuelPosition>3</fuelPosition>
<fuelProd sysid="1">PREM</fuelProd>
<fuelSvcMode sysid="1">SELF</fuelSvcMode>
<fuelMOP sysid="1">CASH</fuelMOP>
<fuelVolume>4.861</fuelVolume>
</trlFuel>
</trLine>
</trLines>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="1">14098</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:14:46-05:00</date>
<duration>0</duration>
<cashier sysid="5" empNum="5" posNum="1" period="1" drawer="1">TURNO 2</cashier>
<posNum>1</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="LOGIN/LOGOUT">SALIR REPORTES # EMPLEADO 005 30/06/16 06:14</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151932</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:15:00-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="FILE DOWNLOAD">30/06/16 06:15 TRANSMIT. ARCHIVOS
 </trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151933</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:15:01-05:00</date>
<duration>0</duration>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="FILE DOWNLOAD">30/06/16 06:15 FIN TRANSMISION
 
 </trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151934</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:15:06-05:00</date>
<duration>0</duration>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjText type="LOGIN/LOGOUT">ENTRAR VENTAS # EMPLEADO 006 30/06/16 06:15</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="autocollect" recalled="false">
<trHeader>
<termMsgSN type="FINANCIAL" term="9">522157</termMsgSN>
<trTickNum>
<posNum>9</posNum>
<trSeq>92208</trSeq>
</trTickNum>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:17:54-05:00</date>
<duration>0</duration>
</trHeader>
<trValue>
<trTotNoTax>100.00</trTotNoTax>
<trCurrTot sysid="1" locale="DOLLAR">100.00</trCurrTot>
</trValue>
<trLines>
<trLine type="autocollect">
<trlTaxes></trlTaxes>
<trlFlags></trlFlags>
<trlDept number="9998" type="fuel">MANUAL FUEL DE</trlDept>
<trlCat number="9999">FUEL DEPOSIT</trlCat>
<trlNetwCode>4</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlUnitPrice>186.900</trlUnitPrice>
<trlLineTot>100.00</trlLineTot>
<trlFuel type="autocollect">
<trlFuelSeq>1</trlFuelSeq>
<fuelPosition>10</fuelPosition>
<fuelProd sysid="2">REG</fuelProd>
<fuelSvcMode sysid="1">SELF</fuelSvcMode>
<fuelMOP sysid="1">CASH</fuelMOP>
<fuelVolume>0.535</fuelVolume>
</trlFuel>
</trLine>
</trLines>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151935</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:22:55-05:00</date>
<duration>0</duration>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjTicketNum>26285</trjTicketNum>
<trjPrintCount>2</trjPrintCount>
<trjText type="RECEIPT PRINTED">Recibo #26285 impreso por cajero #6</trjText>
<marker></marker>
</trJournal>
</trans>
<openCashier>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
<cOpenTime>2016-06-30T06:15:06-05:00</cOpenTime>
<cashierPeriod>876</cashierPeriod>
<beginCash mop="1" cat="0">0.00</beginCash>
<beginFoodStmp mop="0" cat="13">0.00</beginFoodStmp>
</openCashier>
<trans type="openCashier">
<trHeader>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
</trHeader>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
<cOpenTime>2016-06-30T06:15:06-05:00</cOpenTime>
<cashierPeriod>876</cashierPeriod>
<beginCash mop="1" cat="0">0.00</beginCash>
<beginFoodStmp mop="0" cat="13">0.00</beginFoodStmp>
</trans>
<trans type="sale" recalled="false">
<trHeader>
<termMsgSN type="FINANCIAL" term="2">91242</termMsgSN>
<trTickNum>
<posNum>2</posNum>
<trSeq>26285</trSeq>
</trTickNum>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:21:59-05:00</date>
<duration>57</duration>
<till>1</till>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<storeNumber>00002</storeNumber>
</trHeader>
<trValue>
<trTotNoTax>315.00</trTotNoTax>
<trTotWTax>315.00</trTotWTax>
<trTotTax>0.00</trTotTax>
<trTax>
<taxAmts>
<taxAmt sysid="1" cat="ITBIS 18%">315.00</taxAmt>
<taxRate sysid="1" cat="ITBIS 18%">18.000</taxRate>
<taxNet sysid="1" cat="ITBIS 18%">0.00</taxNet>
<taxInTot sysid="1" cat="ITBIS 18%">48.05</taxInTot>
<taxAttribute sysid="1" cat="ITBIS 18%">17</taxAttribute>
<taxForgivenAgainst sysid="1" cat="ITBIS 18%">0.00</taxForgivenAgainst>
<taxForgiven sysid="1" cat="ITBIS 18%">0.00</taxForgiven>
</taxAmts>
</trTax>
<trCurrTot sysid="1" locale="DOLLAR">315.00</trCurrTot>
<trSTotalizer>315.00</trSTotalizer>
<trGTotalizer>315.00</trGTotalizer>
</trValue>
<appSpcfcData>
<LatpakFiscalTran TranType="CONSUMIDOR FINAL">
<FiscalSequenceNumber>A020010020200085684</FiscalSequenceNumber>
<SiteRUC>131071775</SiteRUC>
<CompanyName>COMPANIA </CompanyName>
<SubtotalGravados>315.00</SubtotalGravados>
<SubtotalExentos>0.00</SubtotalExentos>
<FovialTax>0.00</FovialTax>
<IvaTax>48.05</IvaTax>
<AdValoremTax>0.00</AdValoremTax>
<RubyReceiptNumber>
<posNum>2</posNum>
<trSeq>26285</trSeq>
</RubyReceiptNumber>
</LatpakFiscalTran>
</appSpcfcData>
<trLines>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">45.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
<trlCatCust/>
</trlFlags>
<trlDept number="7" type="norm">Bebidas Embote</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>45.000</trlUnitPrice>
<trlLineTot>45.00</trlLineTot>
<trlDesc>JGO RICA FP 16Z </trlDesc>
<trlUPC>00790330021270</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="scanned"></trlUPCEntry>
</trLine>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">145.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
</trlFlags>
<trlDept number="17" type="norm">Snack Alternat</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>145.000</trlUnitPrice>
<trlLineTot>145.00</trlLineTot>
<trlDesc>QUESTBAR COOKIE </trlDesc>
<trlUPC>00888849000005</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="scanned"></trlUPCEntry>
</trLine>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">55.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
</trlFlags>
<trlDept number="29" type="norm">COMIDA PREPARA</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>55.000</trlUnitPrice>
<trlLineTot>55.00</trlLineTot>
<trlDesc>EMPANADA DE QUE </trlDesc>
<trlUPC>00000000029131</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="manual"></trlUPCEntry>
</trLine>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">40.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
</trlFlags>
<trlDept number="29" type="norm">COMIDA PREPARA</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>40.000</trlUnitPrice>
<trlLineTot>40.00</trlLineTot>
<trlDesc>CROQUETAS DE PO </trlDesc>
<trlUPC>00000000029445</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="manual"></trlUPCEntry>
</trLine>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">30.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
</trlFlags>
<trlDept number="30" type="norm">Bebidas Calien</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>30.000</trlUnitPrice>
<trlLineTot>30.00</trlLineTot>
<trlDesc>CAFE ESPRESSO G </trlDesc>
<trlUPC>00000000300100</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="manual"></trlUPCEntry>
</trLine>
</trLines>
<trPaylines>
<trPayline type="sale" sysid="1" locale="DOLLAR">
<trpPaycode mop="1" cat="0">CASH</trpPaycode>
<trpAmt>400.00</trpAmt>
</trPayline>
<trPayline type="sale" sysid="1" locale="DOLLAR">
<trpPaycode mop="1" cat="0">Cambio</trpPaycode>
<trpAmt>-85.00</trpAmt>
</trPayline>
</trPaylines>
</trans>
<trans type="autocollect" recalled="false">
<trHeader>
<termMsgSN type="FINANCIAL" term="9">522158</termMsgSN>
<trTickNum>
<posNum>9</posNum>
<trSeq>92209</trSeq>
</trTickNum>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:24:06-05:00</date>
<duration>0</duration>
</trHeader>
<trValue>
<trTotNoTax>242.40</trTotNoTax>
<trCurrTot sysid="1" locale="DOLLAR">242.40</trCurrTot>
</trValue>
<trLines>
<trLine type="autocollect">
<trlTaxes></trlTaxes>
<trlFlags></trlFlags>
<trlDept number="9998" type="fuel">MANUAL FUEL DE</trlDept>
<trlCat number="9999">FUEL DEPOSIT</trlCat>
<trlNetwCode>4</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlUnitPrice>186.900</trlUnitPrice>
<trlLineTot>242.40</trlLineTot>
<trlFuel type="autocollect">
<trlFuelSeq>1</trlFuelSeq>
<fuelPosition>4</fuelPosition>
<fuelProd sysid="2">REG</fuelProd>
<fuelSvcMode sysid="1">SELF</fuelSvcMode>
<fuelMOP sysid="1">CASH</fuelMOP>
<fuelVolume>1.297</fuelVolume>
</trlFuel>
</trLine>
</trLines>
</trans>
<trans type="journal">
<trHeader>
<termMsgSN type="JOURNAL" term="2">151936</termMsgSN>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:24:13-05:00</date>
<duration>0</duration>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<posNum>2</posNum>
<storeNumber>00002</storeNumber>
</trHeader>
<trJournal>
<trjTicketNum>26286</trjTicketNum>
<trjPrintCount>2</trjPrintCount>
<trjText type="RECEIPT PRINTED">Recibo #26286 impreso por cajero #6</trjText>
<marker></marker>
</trJournal>
</trans>
<trans type="sale" recalled="false">
<trHeader>
<termMsgSN type="FINANCIAL" term="2">91243</termMsgSN>
<trTickNum>
<posNum>2</posNum>
<trSeq>26286</trSeq>
</trTickNum>
<period level="0" seq="6" name="HOUR"></period>
<period level="1" seq="74" name="TURNO"></period>
<period level="2" seq="836" name="DIARIO"></period>
<date>2016-06-30T06:23:33-05:00</date>
<duration>40</duration>
<till>1</till>
<cashier sysid="6" empNum="6" posNum="2" period="876" drawer="1">YENNI TEJADA</cashier>
<storeNumber>00002</storeNumber>
</trHeader>
<trValue>
<trTotNoTax>140.00</trTotNoTax>
<trTotWTax>140.00</trTotWTax>
<trTotTax>0.00</trTotTax>
<trTax>
<taxAmts>
<taxAmt sysid="1" cat="ITBIS 18%">140.00</taxAmt>
<taxRate sysid="1" cat="ITBIS 18%">18.000</taxRate>
<taxNet sysid="1" cat="ITBIS 18%">0.00</taxNet>
<taxInTot sysid="1" cat="ITBIS 18%">21.36</taxInTot>
<taxAttribute sysid="1" cat="ITBIS 18%">17</taxAttribute>
<taxForgivenAgainst sysid="1" cat="ITBIS 18%">0.00</taxForgivenAgainst>
<taxForgiven sysid="1" cat="ITBIS 18%">0.00</taxForgiven>
</taxAmts>
</trTax>
<trCurrTot sysid="1" locale="DOLLAR">140.00</trCurrTot>
<trSTotalizer>140.00</trSTotalizer>
<trGTotalizer>140.00</trGTotalizer>
</trValue>
<appSpcfcData>
<LatpakFiscalTran TranType="CONSUMIDOR FINAL">
<FiscalSequenceNumber>A020010020200085685</FiscalSequenceNumber>
<SiteRUC>131071775</SiteRUC>
<CompanyName>COMPANIA </CompanyName>
<SubtotalGravados>140.00</SubtotalGravados>
<SubtotalExentos>0.00</SubtotalExentos>
<FovialTax>0.00</FovialTax>
<IvaTax>21.36</IvaTax>
<AdValoremTax>0.00</AdValoremTax>
<RubyReceiptNumber>
<posNum>2</posNum>
<trSeq>26286</trSeq>
</RubyReceiptNumber>
</LatpakFiscalTran>
</appSpcfcData>
<trLines>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">35.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
<trlCatCust/>
</trlFlags>
<trlDept number="15" type="norm">Snack Salados</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>35.000</trlUnitPrice>
<trlLineTot>35.00</trlLineTot>
<trlDesc>PLATANOS SAL$35 </trlDesc>
<trlUPC>07464113821618</trlUPC>
<trlModifier>000</trlModifier>
<trlUPCEntry type="scanned"></trlUPCEntry>
</trLine>
<trLine type="plu">
<trlTaxes>
<trlTax sysid="1" cat="ITBIS 18%" reverse="0">50.00</trlTax>
<trlRate sysid="1" cat="ITBIS 18%">18.000</trlRate>
</trlTaxes>
<trlFlags>
<trlPLU/>
<trlUpdPluCust/>
<trlUpdDepCust/>
</trlFlags>
<trlDept number="7" type="norm">Bebidas Embote</trlDept>
<trlNetwCode>7</trlNetwCode>
<trlQty>1.000</trlQty>
<trlSign>1.00</trlSign>
<trlSellUnit>1.000</trlSellUnit>
<trlUnitPrice>50.000</trlUnitPrice>
<trlLineTot>50.00</trlLineTot>
<trlDesc>CHOCO RICA MED. </trlDesc>
<trlUPC

-------------
Busco y comparto mas conocimiento



Respuestas:
Publicado por: Mihura
Fecha de publicación: 02/Septiembre/2016 a las 19:56
http://accessaplicaciones.com/ejemplos.html#m12" rel="nofollow - Ejemplo tratar xml

-------------
Jesús Mansilla Castells.
Saludos desde Móstoles.

http://www.accessaplicaciones.com" rel="nofollow - Access Aplicaciones
http://www.tecsys.es" rel="nofollow - Tecsys.es


Publicado por: emiliove
Fecha de publicación: 03/Septiembre/2016 a las 05:30
Que tablas vas a crear y que campos vas a obtener de tu ejemplo que por cierto le falto:
</trlUPC>
</trLine>
</trLines>
</trans>
</transactionSet>

Saludos.



Imprimir página | Cerrar ventana