Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Chicago, Illinois, USA
    Posts
    187
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Project & Excel (2000)

    Is it possible to export (or link) information from Project 2000 to Excel 2000? My final intent is to get it into Pocket Excel (PocketPC 2002).

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Project & Excel (2000)

    I don't know about Pocket Excel, however, you can use the Save As option to save Project Data in Excel Format. You would then need to set up the mapping tables as required. If you can't link directly from Project to Excel, You can link Project to Access and then Access to Excel. I am sure someone will have a better solution.

    Good Luck.
    Regards,

    Gary
    (It's been a while!)

  3. #3
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project & Excel (2000)

    Be on the look out for Project 2002. It has an option to save as XML which will hopefully have the capability to upload to you Pocket PC!!!! I received the demo version and I am going to see if it works with my HP pocket PC (which already reads Microsoft).

  4. #4
    New Lounger
    Join Date
    Nov 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project & Excel (2000)

    For linking to Excel & access make sure that you select the "Expand Time Phased Data" option under Tools|option|Save. Then set up an export map to export the data you want. I prefer to export to Excel over Access because MSP changes the units for time & duration, while it does not do that when exporting to Excel.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Baltimore, MD, Maryland, USA
    Posts
    254
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project & Excel (2000)

    Maybe but it is a PIA to have to deal with the "hrs", "days", or "wks" that MSP attaches as suffix to the exported data. Does it do the same thing in exporting to Access?

  6. #6
    New Lounger
    Join Date
    Nov 2001
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project & Excel (2000)

    I usually export to Excel, then link those sheets into access. Within Access queries I filter out those labels. It may seem like a lot of extra steps but it gives me the flexibility I want, and I am more confident about the time units. You may prefer to export to Access directly, then check the units for each record. Time data (duration, etc.) exported to access do not have the unit labels in the data fields themselves, but rather another field is used to indicate what unit is shown.

  7. #7
    New Lounger
    Join Date
    Jun 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Project & Excel (2000)

    Have you thought about just using Natara Project@Hand. It nicely syncs Project files to your PDA.

    Cheers,
    Russ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •