Importing XML Document I am getting Error Code: -1072896682

Anonymous
2021-10-05T19:44:10+00:00

Couldn't get Microsoft importers to work so I have figured out that if I copy file, open in notepad, remove the first line and save it I am able to import the XML.

Can I get my import wizard to ignore first line?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2021-10-06T10:00:20+00:00

    Hi Alex,

    Thanks for posting in the community.

    For importing XML data in Excel, pleas view the reference: Import XML data and try other ways to import XML data. Check if it helps or not. If the error message still pops on without removing the first line, the issue is likely caused by the XML file itself. Since we have a specific channel Q&A Community coping with fixing XML file, I suggest you post a new thread there for expert help.

    Sorry for that our category may have limited resources on checking on the issue further.

    Regards,

    George

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful