Problem importing InventTable


I am using AX 2009.

I have exported the “InventTable” and when I import it there are two columns called “WMSArrivalHandlingTime” and “WMSPickingQtyTime” which return as “?” symbols. They are both time data written as “00:00:00” but Excel takes it as “General” data.

I think this happens because Excel changes the type of data but I am not sure. How can I import the table without losing those columns?

Thank you,


It happens to me once, try leaving the cell blank (empty) or with 0 value.