October 31, 2005 at 5:03 pm
Hi All,
I am trying to insert a datetime field from a CVS file using DTS and it fails. Here is sample data of my CVS file 2005101811:25:28.35 and when I try to use Cdate(dtssource("col") it fails. Any help in resolving this issue is greatly appreciated.
October 31, 2005 at 6:10 pm
Your data is a bit fried I think. It should be in the format 2005-10-31 19:50:52.567
A.J.
DBA with an attitude
October 31, 2005 at 6:10 pm
Your data is a bit fried I think. It should be in the format 2005-10-31 19:50:52.567
A.J.
DBA with an attitude
November 2, 2005 at 12:02 am
you can change your transform to convert the mal-formed date:
CDate(Left("2005101811:25:28.35",8) & " " & Right("2005101811:25:28.35",11))
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply