IMPORT FROM EXCEL
Forum Sponsor
Top Posters
Dimitrios Theocharidis
3 posts
MichaelFuelsC
0 posts
anwar zeb
1 posts
olva seselima
1 posts
Muhammd Muneer
0 posts
sairam
0 posts
MARAT BILYALOV
0 posts
RichTea66
0 posts
Muneer Muhammad
1 posts
Manny Onifade
5 posts
To overcome create the spreadsheet, I usually create 2 dummy activities in P3, then export them in DBF format with selected fields.
Open DBF in Excel, do my edit and save it in DBF.
Then import.
Dear Luca
Its very urgent on the subject matter. Please contact me on following e-mail.
[email protected]
I am waiting your reply
William peter
Pay attention to save the file in DBIII format and not DBIV, otherwise P3 will not be able to read it.
Before to run the import You must have close the file in excel or again P3 will be not able to read it.
In Your excel file for each column insert these heading:
ACT Fill with Activity ID
TITLE Fill with Activity title (if You need)
OD Fill with Original duration
Example
ACT TITLE OD
A1000 Cut & fill 10
A1010 Stabiliz 8
Etc …
Then in excel select all the area and from the menu select “Insert->Name->Define” and give a name. You are making a database
Save the file in DBIII format
In P3 “Tools->Project Utilities->Import” write down the path, to Your file example “C:Projfile.dbf” and run it
This topic was discussed hundred times. So find this in reserch:
Transfer data from Excel to P3