Data Migration NAV 2009 Export to Excel error

Hi Everyone,

I am trying to use Data Migration option in NAV 2009 by using Export to excel. And i end up with this error.

"This message is for C/AL programmers:

The call to member createElement failed. msxml6.dll returned the following message:

An invalid character was found in the text content."

I tried exporting tables with less record like Currency and Language. I checked for special symbols like <,>. which  was not present.

The msxml6.dll is present under windows->system32->msxml6.dll. Checked the past posts related to this error and they advised to check for empty field names present under "Migration Table Field", which was not present.

Can someone please enlighten me on where should i look for this type of error? Thanks in advance for your time.