Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    17

    Unanswered: Date field transfer problem!

    Hello guys!

    I have a problem transferring certain table columns
    to excel with DTS. I have a colums where I have date
    and time record like 02.10.03 14.45.33.
    When I transfer this to excel, it loses the time from that
    colums and has only 02.10.03.
    What could be the problem?

    Please help me,
    Jessica

  2. #2
    Join Date
    Sep 2003
    Posts
    39
    You should store the time in a separate column.

  3. #3
    Join Date
    Sep 2003
    Location
    Germany
    Posts
    63
    Hi Jessica,

    how is the exported field defined? TIMESTAMP?
    And, which Task do you use for the export?

    At this point I can imagine that the destination field in Excel has got a format like "DD.MM.YYYY" and not "DD.MM.YYYY hh.mm.ss", so that Excel just hides this information.

    Perhaps I am wrong.... It just should be a guess ;-)

    Greetings,

    Carsten

Posting Permissions

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