Brinkbeibia
New Member
anyone know how to convert xsd schema and xml file into table in sql?\[code\]This XML file does not appear to have any style information associated with it. The document tree is shown below.<link:linkbase xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:link="http://www.xbrl.org/2003/linkbase" xmlns:xbrli="http://www.xbrl.org/2003/instance" xmlns:xlink="http://www.w3.org/1999/xlink" xsi:schemaLocation="http://www.xbrl.org/2003/linkbase http://www.xbrl.org/2003/xbrl-linkbase-2003-12-31.xsd"><link:roleRef roleURI="http://www.bi.go.id/xbrl/role/BSMS5" xlink:type="simple" xlink:href="http://stackoverflow.com/questions/14621837/BSMS5.xsd#BSMS5"/><link:labelLink xlink:type="extended" xlink:role="http://www.bi.go.id/xbrl/role/BSMS5"><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_si2" xlink:label="si2" xlink:title="si2"/><link:label xlink:type="resource" xlink:label="label_si2" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_si2" xml:lang="id" id="label_si2">Jenis Valuta</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="si2" xlink:to="label_si2" xlink:title="label: si2 to label_si2"/><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_mi3" xlink:label="mi3" xlink:title="mi3"/><link:label xlink:type="resource" xlink:label="label_mi3" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_mi3" xml:lang="id" id="label_mi3">Posisi Awal</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="mi3" xlink:to="label_mi3" xlink:title="label: mi3 to label_mi3"/><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_mi4" xlink:label="mi4" xlink:title="mi4"/><link:label xlink:type="resource" xlink:label="label_mi4" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_mi4" xml:lang="id" id="label_mi4">Debet</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="mi4" xlink:to="label_mi4" xlink:title="label: mi4 to label_mi4"/><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_mi5" xlink:label="mi5" xlink:title="mi5"/><link:label xlink:type="resource" xlink:label="label_mi5" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_mi5" xml:lang="id" id="label_mi5">Kredit</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="mi5" xlink:to="label_mi5" xlink:title="label: mi5 to label_mi5"/><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_mi6" xlink:label="mi6" xlink:title="mi6"/><link:label xlink:type="resource" xlink:label="label_mi6" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_mi6" xml:lang="id" id="label_mi6">Lainnya</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="mi6" xlink:to="label_mi6" xlink:title="label: mi6 to label_mi6"/><link:loc xlink:type="locator" xlink:href="http://www.bi.go.id/xbrl/2012-06-18/dict/base/base.xsd#base_mi7" xlink:label="mi7" xlink:title="mi7"/><link:label xlink:type="resource" xlink:label="label_mi7" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_mi7" xml:lang="id" id="label_mi7">Posisi Akhir</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="mi7" xlink:to="label_mi7" xlink:title="label: mi7 to label_mi7"/><link:loc xlink:type="locator" xlink:href="http://stackoverflow.com/questions/14621837/BSMS5.xsd#BSMS5_BSMS5" xlink:label="BSMS5" xlink:title="BSMS5"/><link:label xlink:type="resource" xlink:label="label_BSMS5" xlink:role="http://www.xbrl.org/2003/role/label" xlink:title="label_BSMS5" xml:lang="id" id="label_BSMS5">Rincian Kas dalam Valuta Asing</link:label><link:labelArc xlink:type="arc" xlink:arcrole="http://www.xbrl.org/2003/arcrole/concept-label" xlink:from="BSMS5" xlink:to="label_BSMS5" xlink:title="label: BSMS5 to label_BSMS5"/></link:labelLink></link:linkbase>\[/code\]