importere XML fil

her er et udsnit af XML filen.

<?xml version="1.0" encoding="UTF-8" ?>
- <BMECAT version="2005">
- <HEADER>
  <GENERATOR_INFO>erstellt durch ac.BMECAT 2.0.7.19 by advanced concepts GmbH</GENERATOR_INFO>
- <CATALOG>
  <LANGUAGE>deu</LANGUAGE>
  <CATALOG_ID>Baier</CATALOG_ID>
  <CATALOG_VERSION>001.000</CATALOG_VERSION>
  <CATALOG_NAME>ETIM-Daten Baier</CATALOG_NAME>
- <DATETIME type="generation_date">
  <DATE>2010-12-06</DATE>
  </DATETIME>
  <TERRITORY>DE</TERRITORY>
  <CURRENCY>EUR</CURRENCY>
  <PRICE_FLAG type="incl_freight">FALSE</PRICE_FLAG>
  <PRICE_FLAG type="incl_packing">TRUE</PRICE_FLAG>
  <PRICE_FLAG type="incl_packing">FALSE</PRICE_FLAG>
  <PRICE_FLAG type="incl_assurance">FALSE</PRICE_FLAG>
  <PRICE_FLAG type="incl_duty">FALSE</PRICE_FLAG>
  </CATALOG>
- <BUYER>
  <BUYER_NAME>EGH</BUYER_NAME>
  </BUYER>
- <SUPPLIER>
  <SUPPLIER_ID type="duns">315341669</SUPPLIER_ID>
  <SUPPLIER_NAME>Maschinenfabrik OTTO BAIER GmbH</SUPPLIER_NAME>
- <ADDRESS type="supplier">
  <NAME>Maschinenfabrik OTTO BAIER GmbH</NAME>
  <CONTACT>Frank Eichhorn</CONTACT>
  <STREET>Heckenwiesen 26</STREET>
  <ZIP>71679</ZIP>
  <CITY>Asperg</CITY>
  <STATE>Deutschland</STATE>
  <COUNTRY>Baden-Würthemberg</COUNTRY>
  <PHONE>+49 7141 30 32 42</PHONE>
  <FAX>+49 7141 30 32 43</FAX>
  <EMAIL>baier@baier-tools.de</EMAIL>
  <URL>www.baier-tools.de</URL>
  <ADDRESS_REMARKS>selbst erstellt mit Support durch advanced concepts GmbH</ADDRESS_REMARKS>
  </ADDRESS>
- <MIME_INFO>
- <MIME>
  <MIME_TYPE>image/tif</MIME_TYPE>
  <MIME_SOURCE>Logo_farbig.tif</MIME_SOURCE>
  <MIME_PURPOSE>logo</MIME_PURPOSE>
  </MIME>
- <MIME>
  <MIME_TYPE>image/tif</MIME_TYPE>
  <MIME_SOURCE>Logo_sw.tif</MIME_SOURCE>
  <MIME_PURPOSE>logo</MIME_PURPOSE>
  </MIME>
- <MIME>
  <MIME_TYPE>image/jpeg</MIME_TYPE>
  <MIME_SOURCE>Logo_internet.jpg</MIME_SOURCE>
  <MIME_PURPOSE>logo</MIME_PURPOSE>
  </MIME>
  </MIME_INFO>
  </SUPPLIER>
- <USER_DEFINED_EXTENSIONS>
  <UDX.EDXF.VERSION>2.0</UDX.EDXF.VERSION>
  </USER_DEFINED_EXTENSIONS>
  </HEADER>
- <T_NEW_CATALOG>
- <PRODUCT mode="new">
  <SUPPLIER_PID>10710</SUPPLIER_PID>
- <PRODUCT_DETAILS>
  <DESCRIPTION_SHORT>ELEKTROMETALLHANDSAEGE EHS700</DESCRIPTION_SHORT>
  <DESCRIPTION_LONG>Gefahrlos Metallprofile sägen ohne Funkenflug</DESCRIPTION_LONG>
  <EAN>4046382107100</EAN>
  <SUPPLIER_ALT_PID>10710</SUPPLIER_ALT_PID>
  <MANUFACTURER_PID>10710</MANUFACTURER_PID>
  <MANUFACTURER_NAME>BAIER</MANUFACTURER_NAME>
  <MANUFACTURER_TYPE_DESCR>EHS 700</MANUFACTURER_TYPE_DESCR>
  <SPECIAL_TREATMENT_CLASS type="NOT_RELEVANT">NONE</SPECIAL_TREATMENT_CLASS>
  <KEYWORD>EHS 700 solo</KEYWORD>
  <KEYWORD>Metallsäge</KEYWORD>
  </PRODUCT_DETAILS>
- <PRODUCT_FEATURES>
  <REFERENCE_FEATURE_SYSTEM_NAME>ETIM-4.0</REFERENCE_FEATURE_SYSTEM_NAME>
  <REFERENCE_FEATURE_GROUP_ID>EC001381</REFERENCE_FEATURE_GROUP_ID>
- <FEATURE>
  <FNAME>EF001950</FNAME>
  <FVALUE>850</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF002855</FNAME>
  <FVALUE>175</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF002856</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF005255</FNAME>
  <FVALUE>0</FVALUE>
  <FVALUE>50</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF004988</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF002850</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF002849</FNAME>
  <FVALUE>50</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF004976</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF004977</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF004978</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF004974</FNAME>
  <FVALUE>-</FVALUE>
  </FEATURE>
- <FEATURE>
  <FNAME>EF001951</FNAME>
  <FVALUE>6.5</FVALUE>
  </FEATURE>
  </PRODUCT_FEATURES>
- <PRODUCT_ORDER_DETAILS>
  <ORDER_UNIT>C62</ORDER_UNIT>
  <CONTENT_UNIT>C62</CONTENT_UNIT>
  <NO_CU_PER_OU>1</NO_CU_PER_OU>
  <PRICE_QUANTITY>1</PRICE_QUANTITY>
  <QUANTITY_MIN>1</QUANTITY_MIN>
  <QUANTITY_INTERVAL>1</QUANTITY_INTERVAL>
  </PRODUCT_ORDER_DETAILS>
- <PRODUCT_PRICE_DETAILS>
- <DATETIME type="valid_start_date">
  <DATE>2010-04-01</DATE>
  </DATETIME>
- <PRODUCT_PRICE price_type="net_list">
  <PRICE_AMOUNT>769.00</PRICE_AMOUNT>
  <PRICE_CURRENCY>EUR</PRICE_CURRENCY>
  <TAX>0.19</TAX>
  <LOWER_BOUND>1</LOWER_BOUND>
  </PRODUCT_PRICE>
  </PRODUCT_PRICE_DETAILS>
- <MIME_INFO>
- <MIME>
  <MIME_TYPE>image/jpg</MIME_TYPE>
  <MIME_SOURCE>EHS 700.jpg</MIME_SOURCE>
  <MIME_DESCR>Produktbild</MIME_DESCR>
  <MIME_PURPOSE>normal</MIME_PURPOSE>
  </MIME>
  </MIME_INFO>
- <USER_DEFINED_EXTENSIONS>
  <UDX.EDXF.MANUFACTURER_ACRONYM>Maschinenf</UDX.EDXF.MANUFACTURER_ACRONYM>
  <UDX.EDXF.DISCOUNT_GROUP_MANUFACTURER>2</UDX.EDXF.DISCOUNT_GROUP_MANUFACTURER>
- <UDX.EDXF.PACKING_UNITS>
- <UDX.EDXF.PACKING_UNIT>
  <UDX.EDXF.QUANTITY_MIN>1</UDX.EDXF.QUANTITY_MIN>
  <UDX.EDXF.QUANTITY_MAX>1</UDX.EDXF.QUANTITY_MAX>
  <UDX.EDXF.PACKING_UNIT_CODE>C62</UDX.EDXF.PACKING_UNIT_CODE>
  <UDX.EDXF.EAN>4046382107100</UDX.EDXF.EAN>
  </UDX.EDXF.PACKING_UNIT>
  </UDX.EDXF.PACKING_UNITS>
  </USER_DEFINED_EXTENSIONS>
- <PRODUCT_LOGISTIC_DETAILS>
- <CUSTOMS_TARIFF_NUMBER>
  <CUSTOMS_NUMBER>3139972</CUSTOMS_NUMBER>
  </CUSTOMS_TARIFF_NUMBER>
  <COUNTRY_OF_ORIGIN>DE</COUNTRY_OF_ORIGIN>
  </PRODUCT_LOGISTIC_DETAILS>
  </PRODUCT>

Interessant at access kan finde ud af at lave det til en masse tabeller ved import!

Jeg kommer ikke med nogen løsning, blot en kommentar: Man skyder sig ind på sådan en monster stor fil vha. xslt tranformation. Det er redskaber som årevis har befundet sig i 'redskabskassen'.

Det er en programmerings opgave.

løst selv via anden metode i excel