XML Schema RRS feed

  • Question

  • Hi all,

    I am trying to import XML files into excel but I get a prompt saying "the specified XML source does not refer to a schema. Excel will create a schema based on the XML source data." So I click OK and excel creates a map but it is full of rubbish!, like font size, font type and CommaSeparator etc.

    I have VS 2005 installed, I've opened that XML file in VS, clicked on create schema, it did but looks the same as excels.

    So please tell me how I can go about editing the schema to get relevent/orderly information when importing to excel.

    Friday, July 11, 2014 3:41 AM


All replies