Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Export of Excel 97 dates into MS Project 98 seems not workin

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Brussels
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again,

    I try to use softs for what they are at best: Excel to manipulate dates and tasks names, MS Project to display the GANTT chart (although I used to play with conditional formatting in Excel too.

    However I am at a loss to try to dump Excel dates into MS Project (using in MS Project the Open-Map from Excel file): whatever I do, MS Project considers the dates of Excel as text and not dates (I tried and checked carefully the cell format): therefore the import of data from Excel to MS Project does not work. I even tried to export dates from MS Project to Excel, and the Map keeps on saying the dates of MS Project are text field!!!

    How can I overcome this? Is there any patch to use with Excel or MS Project?

    Thanks for any reply

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Clearwater, FL
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've used project some: have you tried copying the whole column of dates from excel and PASTING them into Project? That might work...

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Brussels
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Yes, it will work indeed, I used it. But I want to automate this (weekly updates).

    Thanks anyway

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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