Hello

I have MS project 2013 and Primavera P6 latest version

I made a schedule with MS Project and now I want to import to primavera. Used two method below but nothing worked.

Method 1)

I tried to export MS Project to excel. and then import from excel to primavera. (First of all the excel 2007 format didnt work. I realized it has to be 97-2003 compatible excel file.) so anyways i saved my excel file in 97-2003 compatible format and then i clicked import in primavera.

but it gave me the following message

"the user preferences used to create this excel file could not be found. importing this file could corrupt your data. please check help for more information about importing data from excel. are you sure you want to continue?" and then i hit yes but nothing got imported.

why did this not work? what should I do?

Method 2)

I saved my MS Project file as XML. And then in primavera I hit import and then MS Project and then XML. Then I select the file and then there are two options (which I dont know what for). I tried both MSP mapping and TRW mapping. None of them worked. It seems to import it but then it says "completed with errors". and nothing comes up in primavera.

why did this not work? what should I do?

Question 1) why did method 1 or 2 not work? what should I have done?

Question 2) before importing in primavera i started a new clean blank file and i arranged its columns the same order as the incoming file. was this necessary or not?

Question 3) there seems to be another option of mpx file. but i dont have that file format. how can we save our MS Project files in mpx format? and may be that will work?

Question 4) which is the easiest cleanest method for me? (in the foreseeable future i dont expect to have very large files  or projects)