Xml den veri alma

Katılım
23 Kasım 2007
Mesajlar
245
Excel Vers. ve Dili
2003
Arkadaşlar merhaba,

Bu şekilde bir xml verisini vb ile nasıl alırız.

Yapmam gerekenenler

access bir klasörü denetleyerek içindeki xml dosyasını açıcak bilgileri tabloya attıktansonra xml dosyasını bir başka dosyaya taşıyacak

gerekenler: vb xml açıp içinden veri almak, vb bir dosyayı başka bir klasöre taşımak

<Order>

<createdate>[Note 1]<createdate/>

<createtime>[Note 2]<createtime/>

<createuser>[Note 3]<createuser/>

<ordno>[ordhdr.ordno]<ordno/>

<compcode>[ordhdr.compcode]<compcode/>

<owner>[ordhdr.ordby]<owner/>

<unitkey>[ordhdr.unitkey]<unitkey/>

<eqpidkey2>[ordhdr.eqpidkey2]<eqpidkey2/>

<cusref>[ordhdr.cusref]<cusref/>

<cusref2>[ordhdr.cusref2]<cusref2/>

<loadno>[ordhdr.loadno]<loadno/>

<import_ref>[ordhdr.import_ref]<import_ref/>

<loading address>[Note 4]<loading address/>

<ldgg4>[ordhdr.ldgg4key]<ldgg4/>

<ldgg2>[ordhdr.ldgg2key]<ldgg2/>

<frldgdate>[ordhdr.frldgdate]<frldgdate/>

<toldgdate>[ordhdr.toldgdate]<toldgdate/>

<discharge address>[Note 5]<discharge address/>

<dchg4>[ordhdr.dchg4key]<dchg4/>

<dchg2>[ordhdr.dchg2key]<dchg2/>

<frdchdate>[ordhdr.frdchdate]<frdchdate/>

<todchdate>[ordhdr.todchdate]<todchdate/>

<delterm>[ordhdr.delterm]<delterm/>

<Product 000>

<tradename>[Note 11]<tradename/>

<loadweight>[ordprod.loadweight]<loadweight/>

<weightunit>[ordprod.wghtunit]<weightunit/>

<Section 000>

<sectcode>[despmov.sectcode]<sectcode/>

<fraddr>#[Note 6]<fraddr/>

<fraddrg4>[despmov.Frg4key]<fraddrg4/>

<fraddrg2>[despmov.Frg2key]<fraddrg2/>

<midpoint>[Note 7]<midpoint/>

<midpointg4>[ Midg4key]<midpointg4/>

<midpointg2>[ Midg2key]<midpointg2/>

<toaddr>[Note 8]<toaddr/>

<toaddrg4>[despmov.Tog4key]<toaddrg4/>

<toaddrg2>[despmov.Tog2key]<toaddrg2/>

<frdate>[despmov.frdate]<frdate/>

<frplanactsts>[despmov.frplanactsts]<frplanactsts/>

<todate>[despmov.todate]<todate/>

<toplanactsts>[despmov.toplanactsts]<toplanactsts/>

<consignee>[Note 9]<consignee/>

<compaddrkey>[despmov.compaddrkey]<compaddrkey/>

<carrier>[Note 10]<carrier/>

<vessel>[despmov.vessel]<vessel/>

<voyage[despmov.voyage]<voyage/>
 
Üst