Forum Discussion
MS Project: Import task from excel(.xlsx) to MS project it shows errors and incorrect information
I assume one of the "errors" you refer to is the long list of predecessors. Attempting to import task links from Excel is difficult at best. Why? Because precisely identifying what the task ID will be in Project is not readily translate with row numbers in Excel.
There is not enough information in your post that gives us much clue as to what may be going wrong.
1. What type of import are you using (i.e. new project, insert, or merge)?
2. What fields are you importing?
3. Are you importing tasks, resources and assignments or just one or two of those elements?
4. You mention getting errors on import. What do the error messages say?
5. What exactly are you trying to do? Yeah, I know you are trying to import but give us some background.
John
1. We are using Append import. Because we need to set the custom project calendar and and project start date. We are also try this by setting up the project as new project , but it's also not working.
2. we are trying to import those fields such as,
| ID | Name | SUMMARY | Outline Level | DURATION | Start | Finish | Actual Start | Actual Finish | Successors | PREDECESSORS | % Complete | TASK MODE | Baseline Start | Baseline Finish | CRITICAL | Activity Type | CONSTRAINT_DATE | CONSTRAINT_TYPE |
3. Now we are importing tasks only.
4.
5. We are trying to do is ,we have some data about project. The project contains 8000+ tasks and it has task links. We need to calculate the time duration taken by project and each task.is that everything is going fine. But the bad thing is we cant import the excel to the MS Project with out any errors.
[we are attaching the excel file along with it]
https://wrenchsolutions-my.sharepoint.com/:x:/p/anandhan_j/Ee8bRemrZXRCtqARlnFHSdUBjjsMuoydSpkNzT_oEIy5tw?e=pQRAkm