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,
JessicaYou should store the time in a separate column.|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment