Logon Error while importing data

[Former Member]

Hello,

I have "Countries" flat table in my repository containing 2 fields Name & ISO Code.

I wanted to import data i.e. Name & ISO Code in this flat table via Import Manager.

I have excel file containing Name & ISO Code data.

While importing data, I am getting an error:- "Logon Error: External table is not in the expected format."

Would anybody know about this issue?

Regards,

Vikas

[Former Member]

Hi vikas,

Your excel is not properly maintained and there is some problem in the structure of excel file.

Just try to change the structure of excel.

Thanks,

Sudhanshu

[Former Member]

Hello Sudhanshu,

Both the excel and table structure is identical.

The format, length & sequence of data in excel is also correct.

Still this problem occurs.

Regards,

Vikas

[Former Member]

Hi Vikas,

Just check whether yr file .xls or .xlsx.

If xlsx then change it to xls and check if problem is solved .

If not try with disable macros.

Please revert with yr results.

Thanks,

sudhanshu

[Former Member]

Hello Sudhanshu,

The problem has been resolved.

The issue was with the excel version.

The file has been saved in old excel ver 5.0/95 and it has worked.

Thanks.

Regards,

Vikas