Data import from excel to project 1

[tonew]

Hi there,I was wondering if there is any way I could compare fields between excel and microsoft project and import values that matches the comparison.suppose I have two columns in excel named "Sky" and "River". I also have two fields in microsoft project named "sky" and "River". In my project file "Sky" column is already populated. Now I want to compare between project "Sky" column and excel "Sky" column. if they matches then my "river" field in project will be filled with data associated with excel river.I will really appreciate youir help!


Excel data
[pre][box]sky | river[/box][/pre]
[pre][box]blue | white[/box][/pre]
[pre][box]white | clear [/box] [/pre]
[pre][box]dark | black[/box][/pre]
[pre][box]black | shiny[/box] [/pre]

Project data
[pre][box]sky | river[/box][/pre]
[pre][box]blue | [/box] [/pre]
[pre][box]black | [/box] [/pre]
​

 

[SkipVought]

Are you sure that there is not a place to chose the [highlight]field names[/highlight], as you did with the sheet name?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[JulieInMaine]

Project has had hiccups before when there are spaces in the Tab name in Excel or special characters. I would not try appending just try a straight import to see how much data you can capture. If you'd care to post a sample of the Excel file, we'll try to help.

 

[tonew]

Hi Guys,Thanks a lot for your help.I was able to import with lookup from Excel to MSP.Really appreciate your help!

 

[JulieInMaine]

Great. Glad you were able to get things sorted.