I am using the data migration function in NAV 2009. And I have an Excel sheet but if I try: Functions ==> Import from Excel I will get the error message:Excel does not contain XML mappings

How to solve this issue?

Check the mappings of excel file with column specified in data migration
Better to use dataport to import . It is faster and easier

Dataports faster and easier??

Well not always. The rapidstart/migration tool is fine! If you know how to use it… [;)]

But when using the data migration tool in NAV 2009 (and later for that matter), then you should always use the same file as created by NAV as the template. And then copy the data into this Excel file. Not the other way around, as that will mess up the column definitions.

Oke, thank you