Skip to content

IMPORT FROM EXCEL

Forum GuestMember for 17 years 8 months
Created
5
1
0


CAN ANYONE TELL ME HOW TO IMPORT A LONG ACTIVITY LISTING WITH DURATIONS FROM EWXCEL TO P3

5 replies

Oldest first
  1. 0
    Shahzad Munawar ·
    This topic was discussed hundred times. So find this in reserch:

    Transfer data from Excel to P3
  2. 0
    Luca Basile ·
    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
  3. 0
    Luca Basile ·
    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.
  4. 0
    Forum Guest ·
    Dear Luca

    Its very urgent on the subject matter. Please contact me on following e-mail.
    lasmodn@yahoo.com

    I am waiting your reply

    William peter
  5. 0
    Mk Tse ·
    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.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?