-----Original Message-----
Hello,
Did you set a "merge key" for the map while you imported the Excel data ? If
so, which one ?
the "Unique ID" ?
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
"(e-mail address removed)"
-----Original Message-----
Hello,
Did you set a "merge key" for the map while you imported the Excel data ? If
so, which one ?
the "Unique ID" ?
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
"(e-mail address removed)"
-----Original Message-----
Humm... if you don't know what is the "Unique ID" field, I understand why
you meet some problems during the data import.
MS Project needs a true identifier to drop a piece of data on the correct
row. Insert the Unique ID field in the map definition (for export and for
import) and try again. Tell me if it works.
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
<[email protected]> a écrit dans le message de
Yes, I am setting a "Merge key". I'm not sure what you
mean by "Unique ID". I don't think project will allow
merging data as MS Word does. I would the the map to allow
a new column in the existing project file. Instead of
appending to the end.-----Original Message-----
Hello,
Did you set a "merge key" for the map while you imported the Excel data ? If
so, which one ?
the "Unique ID" ?
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
"(e-mail address removed)"
.
-----Original Message-----
Humm... if you don't know what is the "Unique ID" field, I understand why
you meet some problems during the data import.
MS Project needs a true identifier to drop a piece of data on the correct
row. Insert the Unique ID field in the map definition (for export and for
import) and try again. Tell me if it works.
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
<[email protected]> a écrit dans le message de
Yes, I am setting a "Merge key". I'm not sure what you
mean by "Unique ID". I don't think project will allow
merging data as MS Word does. I would the the map to allow
a new column in the existing project file. Instead of
appending to the end.-----Original Message-----
Hello,
Did you set a "merge key" for the map while you imported the Excel data ? If
so, which one ?
the "Unique ID" ?
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
"(e-mail address removed)"
.
-----Original Message-----
Yes, the mapping can fill in a column with data from excel, but you have to
set a merge key.
Do the following :
File / Open / Files of type : Microsoft Excel Workbooks (*.xls) / open...
then follow the instructions...
Gérard Ducouret
<[email protected]> a écrit dans le message de
No... I want this to apply to a "Column" when I merge not
append to a row. Do you know if the import mapping will
merging of column data.(column wise)-----Original Message-----
Humm... if you don't know what is the "Unique ID" field, I understand why
you meet some problems during the data import.
MS Project needs a true identifier to drop a piece of data on the correct
row. Insert the Unique ID field in the map definition (for export and for
import) and try again. Tell me if it works.
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
<[email protected]> a écrit dans le message de
Yes, I am setting a "Merge key". I'm not sure what you
mean by "Unique ID". I don't think project will allow
merging data as MS Word does. I would the the map to allow
a new column in the existing project file. Instead of
appending to the end.-----Original Message-----
Hello,
Did you set a "merge key" for the map while you imported the Excel data ? If
so, which one ?
the "Unique ID" ?
Gérard Ducouret [Project MVP]
PragmaSoft ® - Paris
"(e-mail address removed)"le message de [email protected]...
Importing Excel to project
Why does the "Merge into an existing Project file" appends
the Excel file to the last row of the Project?
.
.
.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.