Importing and appending data in Project

[yashr]

Hello : I am new to Project and I am trying to import task information into
project from an excel sheet. It seems to work fine but it always appends the
imported data to the very end of the project. Is there a way to append these
tasks in between tasks?
We use templates and sometimes have to delete a few tasks and add tasks
from an external source.
Any suggestions will be appreciated.

Thanks.

 

[PDQBach]

I do not know of any way to specify where imported tasks are to be inserted.

Frankly, I don't think I've ever bothered with importing tasks that way. I just open up the spreadsheet and the project schedule. Then I make certain that the schedule columns displayed correspond with the Excel columns and do a simple copy&paste. Since you want to insert tasks between existing tasks in your schedule, sounds to me as if you'll have do something very similar to what I do.

 

[psbsmms]

You cam merge and append individual tasks by using a key field when mapping the import. I do this between an Access DB and Project.

 

[yashr]

psbsmms
I tried both appending and merging thru the Wizard and both adds tasks to the end of the project.
I tried using a custom field which I mapped to the task_id. It still got appended to the very end.
This is what I am trying :

Template - task 1, task 4
Excel - taks 2, task 3
when I import - I need task 1,2,3,4. Now it just comes up as 1,4,2,3.
Any help is appreciated.