[belajar-access] Re: vba - import xml to Backend

buat sub rutin :
sub subexportxlm
filexml = CurrentProject.Path & "\hasilexport.xml"
filetable = "Inventory"
Application.ExportXML ObjectType:=acExportTable, _
DataSource:=filetable, DataTarget:=filexml
end sub

hasil export ( saya pakai Access 2010 ) :

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2011-03-22T16:05:34">
<Inventory>
<ComputerName>atl-fs-01</ComputerName>
</Inventory>
</dataroot>

'semoga membantu
--- In belajar-access@yahoogroups.com, "Deden" <soeasy_goin@...> wrote:
>
>
>
> terima kasih pak atas masukannya,
>
> in progress buat kebalikannya convert dari data msaccess ke xml..:), kalo mentok baru nanya lagi ke belajar-access
>
> terima kasih
>
> Rgds,
> deden
>
> --- In belajar-access@yahoogroups.com, "sudarsono" <jkssbma@> wrote:
> >
> > Wah sebuah link yang bagus:
> >
> > buat dengan notepad test.xml :
> >
> > <?xml version="1.0" encoding="UTF-8"?>
> > <Inventory>
> > <ComputerName>atl-fs-01</ComputerName>
> > </Inventory>
> >
> > '======
> > saya buat sub rutin di modul vba
> > misal :
> > sub coba2
> > Const acAppendData = 2
> > filexml = CurrentProject.Path & "\test.xml"
> > Application.ImportXML filexml, acAppendData
> > end sub
> >
> >
> > lalu pencet deh [F5]
> > maka data yang berformat xml di import ke tabel Inventory , field
> > ComputerName
> > Tabel Inventory dapat juga merupakan Link ke sebuah database ( BE ).
> >
> >
> > 'trim's atas link yg bagus
> >
> >
> >
> > --- In belajar-access@yahoogroups.com, easy goin <soeasy_goin@> wrote:
> > >
> > > dear pakar access,
> > > mohon bantuannya untuk vba import dari xml file ke backend msaccess, ada beberapa sumber yg saya dapatkan, tapi terkendala pengaplikasiannya, mungkin ada rekans sekalian yg mempunyai trik yg lebih simple.
> > > mohon maaf jika pertanyaannya masih basic berhubung newbie
> > >
> > > http://technet.microsoft.com/en-us/library/ee692914.aspx
> > >
> > >
> > > terima kasih atas bantuannya
> > >
> > > rgds,deden
> > >
> >
>

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/