XML Utility

[Guest]

Does anyone know of a good utility for importing XML into Access, or for
converting XML to a TXT or CSV file?

Thanks

 

[Douglas J. Steele]

Access has the ability to import XML without any 3rd party utilities, unless
you're talking Access 97 or earlier. (Actually, I'm not 100% certain Access
2000 has the ability either)

 

[Guest]

Hi Doug,
Thanks for your reply. I have used the Access XML import utility, but it
misses data when an XML tag is not defined in the first occurrence of an XML
entity ie:

- <vehicleCoverage ID="128">
<vehicleCoveragePackage CA_ID="2312" LITERAL="Rental Reimbursement"
QTAG="30007-1">RR</vehicleCoveragePackage>
<vehicleCoverageTermPremium CA_ID="2371"
QTAG="30007-2">7.0</vehicleCoverageTermPremium>
<vehicleCoverageSeqNumber CA_ID="0"
QTAG="30007-3">230</vehicleCoverageSeqNumber>
<coveragePresenceVehicle CA_ID="3913" LITERAL="Yes" PREV_VALUE="Y"
PREV_VALUE_LITERAL="Yes" QTAG="30007-4">Y</coveragePresenceVehicle>
<vehicleCoverageName CA_ID="0" QTAG="30007-5">Rental
Reimbursement</vehicleCoverageName>
<vehicleCoverageType CA_ID="0" LITERAL="Primary"
QTAG="30007-6">P</vehicleCoverageType>
<vehicleCoverageLimit CA_ID="2313" LITERAL="40/1,200"
QTAG="30007-7">40/1200</vehicleCoverageLimit>
<vehicleCoverageParentCode CA_ID="0"
QTAG="30007-9">COMP</vehicleCoverageParentCode>
<vehicleLimit1 CA_ID="2314" QTAG="30007-13">40</vehicleLimit1>
<vehicleLimit2 CA_ID="2315" QTAG="30007-14">1200</vehicleLimit2>
<vehicleCoverageWrittenPremium CA_ID="2372"
QTAG="30007-16">7.0</vehicleCoverageWrittenPremium>
<vehicleCoverageStructure CA_ID="0" LITERAL="Additional Questions"
QTAG="30007-47">NORM</vehicleCoverageStructure>
<vehicleCoverageManuallyRatedIndicator CA_ID="2370" LITERAL="Rated"
QTAG="30007-53">N</vehicleCoverageManuallyRatedIndicator>
<vehicleCoverageCode CA_ID="2316" QTAG="30007-57">RR</vehicleCoverageCode>
<vehicleCoverageLimitLiteralText CA_ID="0" QTAG="30007-70">per
day/maximum</vehicleCoverageLimitLiteralText>
</vehicleCoverage>

The data above imports fine.

The following data imports, but the coverageDeductible tag/data is not
imported:

- <vehicleCoverage ACTION="U" ID="122">
<vehicleCoveragePackage CA_ID="2235" LITERAL="Collision"
QTAG="30007-1">COLL</vehicleCoveragePackage>
<vehicleCoverageTermPremium ACTION="U" CA_ID="3908" PREV_VALUE="102.0"
QTAG="30007-2">103.0</vehicleCoverageTermPremium>
<vehicleCoverageSeqNumber CA_ID="0"
QTAG="30007-3">210</vehicleCoverageSeqNumber>
<coveragePresenceVehicle CA_ID="3910" LITERAL="Yes" PREV_VALUE="Y"
PREV_VALUE_LITERAL="Yes" QTAG="30007-4">Y</coveragePresenceVehicle>
<vehicleCoverageName CA_ID="0"
QTAG="30007-5">Collision</vehicleCoverageName>
<vehicleCoverageType CA_ID="0" LITERAL="Primary"
QTAG="30007-6">P</vehicleCoverageType>
<coverageDeductible CA_ID="2238" LITERAL="500 Ded"
QTAG="30007-8">500</coverageDeductible>
<vehicleCoverageParentCode CA_ID="0"
QTAG="30007-9">COMP</vehicleCoverageParentCode>
<vehicleCoverageWrittenPremium ACTION="U" CA_ID="3909" PREV_VALUE="102.0"
QTAG="30007-16">103.0</vehicleCoverageWrittenPremium>
<vehicleCoverageStructure CA_ID="2236" LITERAL="Additional Questions"
QTAG="30007-47">NORM</vehicleCoverageStructure>
<vehicleCoverageManuallyRatedIndicator CA_ID="2358" LITERAL="Rated"
QTAG="30007-53">N</vehicleCoverageManuallyRatedIndicator>
<vehicleCoverageCode CA_ID="2237"
QTAG="30007-57">COLL</vehicleCoverageCode>
</vehicleCoverage>

Thanks,