'Could not load selected type library' and problem with Date in Data Migration

Hi everybody,

I’m getting crazy with this:

I wanted to use the page NAV Data Migration to import data (NAV 6.0). The sequence was: write data in sql table (with a query) Migration Record and Migration Data. Then I try to apply them and the records are imported correctly, but the Date fields are blank.

Reading on the internet it seems to be a problem in Automation objects. I don’t know much about them, but I found that really some Automation variables are missing in CodeUnit 8611: XlBook, XlApp, XlBook. Beside them is written: “Unknown Automation Server.Unknown Class”

The other problem is that I cannot compile this Code Unit nor save it. But the main issue is that I don’t know how to fix this problem.

If the solution is in finding these files and re-register them, I cannot find these files anywhere in my pc or my collegues’… I don’t even know if the problem is in this Code Unit… We have tried an import in NAV 5.0 and the Code Unit has the same problem of Automation, but import behave correctly with dates…

I know I did not make myself so clear…

but thanks!

My guess is that Excel is not installed on that machine.

You’re right!

I’ll install it… and tell you if that was the (only) problem

Thank you… and stay tuned! :slight_smile: