Uplouad excel file to MDM cat. - External table isnt in the expected format

[Former Member]

Hi expert,

We try to uploud an excel file to the SRM-MDM catalog 3.0 but when I connect to source and pick my excel file I get error message

"External table is not in the expected format".

I tried to uploud a very simple file, such as hierarchy file or supllier file.

Does anyone can help?

Thanks for your help!

Lori

[Former Member · Accepted solution]

1st check if you choose the File type as Excel in the Import manager !

then make sure the excel is saved as .xls extension ONLY

also check whats the version of the excel ? I mean excel 2003 , 2007 (i know these work)

thanks

-Adrivit

[Former Member · Accepted solution]

Thanks!