Microsoft Project Member for 22 years 9 months Member for 22 years 9 months Submitted by Alexandre Faul… on Wed, 2008-05-28 12:34 Permalink RE: Import P3 Basline/ Target in MSP2003 Damien, a) I would export both the P3 schedule and the target data to wk1 or dbf files (wk1 files do not accomodate more than 2500 rows) b) Then save a blank MS Project file as Excel worksheet with all the necessary fields (see: export map in the online help if necessary) c) Then open the wk1 or dbf files with Excel d) Then carefully paste the date from these files to the template created in b) e) Then open the Excel file in MS Project f) Cross fingers as much as necessary Nota Bene: I hope that your P3 scheduling options are MS Project compatible (constraints, ...) Tell me if it worked well when you are finished Alexandre Member for 18 years 3 months Member for 18 years 3 months Submitted by L.E.N. Lewis on Tue, 2008-05-27 16:31 Permalink RE: Import P3 Basline/ Target in MSP2003 I know nothing of how P3 exports data so that it can be imported by MSPrj. Perhaps you could begin by telling me the process and describing the file exported by P3. Log in or register to post comments
Member for 22 years 9 months Member for 22 years 9 months Submitted by Alexandre Faul… on Wed, 2008-05-28 12:34 Permalink RE: Import P3 Basline/ Target in MSP2003 Damien, a) I would export both the P3 schedule and the target data to wk1 or dbf files (wk1 files do not accomodate more than 2500 rows) b) Then save a blank MS Project file as Excel worksheet with all the necessary fields (see: export map in the online help if necessary) c) Then open the wk1 or dbf files with Excel d) Then carefully paste the date from these files to the template created in b) e) Then open the Excel file in MS Project f) Cross fingers as much as necessary Nota Bene: I hope that your P3 scheduling options are MS Project compatible (constraints, ...) Tell me if it worked well when you are finished Alexandre
Member for 18 years 3 months Member for 18 years 3 months Submitted by L.E.N. Lewis on Tue, 2008-05-27 16:31 Permalink RE: Import P3 Basline/ Target in MSP2003 I know nothing of how P3 exports data so that it can be imported by MSPrj. Perhaps you could begin by telling me the process and describing the file exported by P3.
Member for
22 years 9 monthsRE: Import P3 Basline/ Target in MSP2003
Damien,
a) I would export both the P3 schedule and the target data to wk1 or dbf files (wk1 files do not accomodate more than 2500 rows)
b) Then save a blank MS Project file as Excel worksheet with all the necessary fields (see: export map in the online help if necessary)
c) Then open the wk1 or dbf files with Excel
d) Then carefully paste the date from these files to the template created in b)
e) Then open the Excel file in MS Project
f) Cross fingers as much as necessary
Nota Bene: I hope that your P3 scheduling options are MS Project compatible (constraints, ...)
Tell me if it worked well when you are finished
Alexandre
Member for
18 years 3 monthsRE: Import P3 Basline/ Target in MSP2003
I know nothing of how P3 exports data so that it can be imported by MSPrj.
Perhaps you could begin by telling me the process and describing the file exported by P3.