import data failed via DTS import

Last Post 13 May 2005 08:30 PM by samkry. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
samkry
New Member
New Member

--
13 May 2005 08:30 PM
Hi..
I've csv file that failed to import into sql database...I'm creating the csv thru a web pages interface...

below is the content in my csv
1954410,"33FE02EE",8/8/2004 9:25:49 PM,8/10/2004 12:47:12 PM,"MMRMINA006871","PMRMINA000241",8/10/2004 12:47:12 PM,"CU5",37,350,"051-16646894","","","","33FE02EE","C95MEQ3RBR","154706OM","08998668261503966708049404","ODMCP00203005-114-01","01","154706","","",""


while importing, it prompt an error too many white space exits, i suspect it was beacuse of the date and time format...
so is there any way that I can have the date an time format as below

2004-09-24 13:10:52.447000000


Acceptable Use Policy
---