Skip to content
ProjectControls.com
Primavera Project Planner - P3

To all Experts

In the Open Standard
Moutaz AldeibMember for 22 years 9 months
Created
7
4
0
Dear Planners,

I used to produce tabular resourse report by exporting data to excel file using file format WK1 or WKS, but I was shocked when I tried to export data to excel 2007 as the WK1 and WKS formats are not supported by excel 2007.

Is there any one can help solving this problem.

I will be gratefule for that.

Regards,

Moutaz
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    Rafael Davila ·
    #1
    When importing it is often easier to work with the DBF format which may be opened with Excel.

    Importing/Exporting with the DBF

    The following is a screen capture video using DBF format to import and filter relationship lag showing the procedure in action.

    Sample Video

    Best regards,
    Rafael
    Report
  2. 0
    Moutaz Aldeib ·
    #2
    Dear Rafael,

    Thanks for your response.
    the DBF format is not supported by excel 2007, consequently can not be opened.

    Regards,

    Moutaz
    Report
  3. 0
    Dieter Wambach ·
    #3
    Moutaz

    EXCEL 2007 doesn’t support wks/wk1. The following link contains a freeware:

    http://www.rl-software.com/converter/wks-wdb-to-excel.htm

    But: I never used it. So I can’t give any information on its liability.

    Good luck!

    Dieter
    Report
  4. 0
    Rafael Davila ·
    #4
    Moutaz

    The DBF format can be read by Excel 2007, just it will not open it automatically.

    You have to either:

    1) Right click on the dbf file, select open with, and choose Excel.

    2) You can set up your system to open DBF file extension with Excel automatically.

    You can download the movie, there you will see the file format is in DBF and that it was opened using Excel 2007, you will recognize 2007 ribbon.

    To unpack the file you might need some utility like IZArc, you can downoad it from the foloowing link.

    izarc.org

    I have no much work for the moment so if I can be of any help don’t hesitate to ask for more assistance if you wish.

    I am also to try Dieter suggestion as another avilable alternative, although I still believe with a right click and open with Excel saves you a step. Note that the wks conversion utility does not work with Excel 2007, that there will be a stand alone utility but is not avilable yet.

    Best regards,
    Rafael
    Report
  5. 0
    Moutaz Aldeib ·
    #5
    Dear Rafeal,

    Thanks so much for your response and your offer.

    I managed to open it through DBF, however, the results I got are not the same as I convert it through WK1 and WKS.

    Regards,

    Moutaz
    Report
  6. 0
    Rafael Davila ·
    #6
    moutaz

    I had a good experience with Excel; it opened the file with the fields under different cells. Then I could run an Excel filter very easily.

    There are many ways to skin a cat, you should use the one best fit you.

    Best regards,
    Rafael
    Report
  7. 0
    Zq qz ·
    #7
    just use your old method, but instead of WK1....wks....just leave it blank....

    oki doki.
    Report

Log in or join to reply

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

Log inJoin free

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