Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Forum    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
XML File Import Errors
Albert Rodrigues 
       
7 months ago
I am trying to import the XML file seen below.  It throws an error most of the time, saying Microsoft Access has encountered an error processing in file XXXXX.XML. Illegal xml Character."

Unfortunately, the file is a long file and it won't paste the whole file.

Details
  1217599
  
  IN_PROGRESS
  
  ABC1234567089/ABC1995
   ABCDE ABC ABCDEFGHIGK ABCDEFGH
  CONTACT MISSION POC FOR FURTHER INFORMATION, INCLUDING SERVICING INFORMATION
  ABCDEFGHI
  
  
  
  
  ABCKDEFHI ABCDE
  
  AB ABC ABCC/ABCDE
  ABCDEFGHIJK
  clteeter
  1235-02-12 01:10
  
    
    ABCDE, TYUIO
    

    
    123 ABC/ABCDE
    123-456-7899
    
    
    
    [email protected];[email protected]
    
  

  
    
    
    
    <table class='table table-bordered table-hover table-striped table-compact table-strong-header monospace'><thead><tr><th style='width:50px;'>On</th><th style='width:50px;'>Off</th><th style='width:75px;' title='AB/ABCD Code and ID'>CD &amp; ID</th><th style='width:50px;' title='Class, Division, Component Group Code'>Class</th><th>Proper Shipping Name</th><th>Description</th><th style='width:60px;' title='Pieces'>PCS</th><th style='width:100px;'>Weight<br />(lbs)</th><th style='width:100px;'>Weight<br />(kgs)</th><th style='width:100px;' title='Abc Abcdefg Abcdef'>N.E.W.<br />(kgs)</th></tr></thead><tbody><tr><td>YPDN</td><td>KTCM</td><td>UN&nbsp;3166</td><td>9</td><td>ABCDE, ABCDE ABCD, ABCD, ABCDE ABCDE</td><td>Abcdedf, abcdefg abcde abc, abcd abcd, abcdefgh abc</td><td>1</td><td>12356.12356.000</td><td>15,111.1</td><td></td></tr><tr><td>ABCD</td><td>ABCDEF</td><td>UN&nbsp;3166</td><td>9</td><td>ABCDEDF,ABDE ABCDEFS ABO OR ABC, ABCDEF ABCDEFS</td><td>ABCDEDF,ABDE ABCDEFS ABO OR ABC, ABCDEF ABCDEFS</td><td>1</td><td>123540.000</td><td>1,11001.0</td><td></td></tr></tbody></table>
    true
  

  
    8
    
    
    ABCDE,?ABCDEFS?J
    ABC
    
    false
    false
  

  
    
      1234567
      Abdcdef hight
      ABCDEF ABC
      ABCD
      
      2134-01-11 00:11
      ABCD ABD/ABCD
      
      
      
      
      
      
      
      
      false
      false
      false
      
      2134-01-11 11:11
      
      true
      true
      
      
      
      true
      false
      false
      
        N/A
        ABC
        false
        false
        
        
        false
        false
      

      ABC
    

    
      12345678/id>
      Abcdefg Hijklm
      ABCDE A ABCDE ABCD
      ABCD
      1234-15-12 00:11
      1234-15-12 11:00
      ABCDE FGHI/ABCDE
      
      
      
      
      
      
      
      
      false
      false
      false
      
      1234-15-12 00:11
      1234-15-12 01:10
      true
      true
      
      
      
      false
      false
      true
      
        N/A
        ABC
        false
        false
        
        
        false
        false
      

      ABC
    

    
      1234567
      Abcd
      ABCDEFG ABC
      ABCD
      1234-15-12 21:12
      1234-11-22 12:21
      ABCDE FGHI/ABCD
      
      
      
      
      
      
      
      
      false
      false
      false
      
      1234-15-12 11:00
      4321-11-12 00:11
      true
      true
      
      
      
      false
      false
      true
      
        N/A
        ABC
        false
        false
        
        
        false
        false
      

      ABC
    

    
      123456
      Abcdefgh
      
      
      1234-15-12 11:00
      1234-15-12 00:11
      ABCDEFG
      ABCDE
       ABCDE BCDED ABC ABI A11 BAC A111 APCDE
      ABCDE
      
      
      
      
      
      true
      true
      false
      ****************************************************************************************************
ANY MODIFICATION REQUIRES AN EMAIL NOTIFICATION TO [email protected]

ONLY UPDATING DOES NOT CONTSTITUTE A NOTIFICATION

FULLY READ THE FOLLOWING:

*******ABCD ADHAHF AAKDAL ALDLALDDL ALDLALD ALDLAFKDLALD.  *****************

ABCDE ADN ADLAF/AFAD ADAJKDJF.

EMAIL [email protected] WITH ANY CHANGES


Abcd adada ajfadjf ajdflja fja flfjajdfajfljalkjagjag galdjgaljg.

Abcd AFAKJ LGJAKJG AKJGKD JGKAJG AKJGA JGDAJG AJGA KJGLKAJGAKJG/XXXXX.

ABC ANALGKJGJKGJDLK DJGKAJG KAJGLKAJGLDKJGLKAJALKJ 123/321 ANDKALFLAJ.  

Abndl knglajgla  ganlkgnja.  

EMAIL [email protected] AND AND ANDNFANL

              
ABC Aandlknf Jaj Aldkjf Adfjaljdkja Taean:

Email: [email protected];                                                                

Richard Rost  @Reply  
           
7 months ago
This does not look like a valid XML file. A proper XML document should always have everything enclosed in tags, with one single root element that wraps the whole file. Every tag should open and close properly, and values should be between those tags.

For example, instead of what you showed:

Codeid123456/id  
statusIN_PROGRESS/status


It should look like this:

Code<AircraftRequest>  
  <id>123456</id>  
  <status>IN_PROGRESS</status>  
</AircraftRequest>


If you need to include blocks of HTML or other non-XML text, those should usually be wrapped in CDATA sections, like this:

Code<hazardous><![CDATA[  
  <table>  
    ... your raw HTML table here ...  
  </table>  
]]></hazardous>


So the main problems with your file are:

* Tags are missing < > brackets.
* Elements are not nested correctly.
* You may have raw HTML mixed in, which is not valid XML unless wrapped in CDATA.
* There is no single root element at the top of the file.

Until the structure is corrected, Access (or any XML parser) will throw errors.
Richard Rost  @Reply  
           
7 months ago
Unless, of course, this is just because of how you're posting it on the website. The sample that you sent me in email looks just like what you posted. So maybe post a screenshot of what the top of it looks like with some data. That might give me a clearer picture of what you've got there.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/7/2026 11:43:10 AM. PLT: 0s