locked
MDS -Excel add in -2014 error RRS feed

  • Question

  • I am working on SQL SERVER 2014. I connected through excel add in MDS and trying to create a new entity. I am getting the

    following error. I couldn't find an special characters in the column name in excel. I couldn't move forward. I am new to MDS.

    MDS error

    Thanks in advance


    Vibha

    Tuesday, October 13, 2015 9:08 PM

Answers

  • I got the issue resolved. Removed all the special characters. My sheet has the date headers with'/'.

    I updated the headers and was able to create the entity.

    Thanks


    Vibha

    • Marked as answer by Charlie Liao Friday, October 30, 2015 6:45 AM
    Thursday, October 15, 2015 4:08 PM

All replies

  • When you create entity and attribute, you need avoid use the special character list above.
    Wednesday, October 14, 2015 12:08 AM
  • I have a excel spreadsheet source.How can i modify the attributes cells in the excel sheet. I couldnt see any special characters in the header, but getting the same error

    Vibha

    Wednesday, October 14, 2015 12:14 AM
  • can you click the header and check if the header has an leading single quote?
    Wednesday, October 14, 2015 6:09 PM
  • I got the issue resolved. Removed all the special characters. My sheet has the date headers with'/'.

    I updated the headers and was able to create the entity.

    Thanks


    Vibha

    • Marked as answer by Charlie Liao Friday, October 30, 2015 6:45 AM
    Thursday, October 15, 2015 4:08 PM
  • Hi Vibha,

    Glad to hear that you issue had been solved. Thank you for your sharing. Please mark the corresponding reply which will help others to find the solution.

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, October 16, 2015 6:41 AM