"INSERT INTO temptable(code,sdatetime,photoname,photoname1,hjudge,sdatetime1) VALUES(" _
& recSelect.Fields("code") & ",#" & CStr(Format(recSelect.Fields("sdatetime"), "yyyy-mm-dd hh:mm:ss")) & "#" _
& "," & recSelect.Fields("photoname") & "," & recSelect.Fields("photoname1") & "," _
& recSelect.Fields("hjudge") & ",#" & CStr(Format(recSelect.Fields("sdatetime1"), "yyyy-mm-dd hh:mm:ss")) & "#)"你把这一串负值了以后,msgbox一下就知道有没有问题了
& recSelect.Fields("code") & ",#" & CStr(Format(recSelect.Fields("sdatetime"), "yyyy-mm-dd hh:mm:ss")) & "#" _
& "," & recSelect.Fields("photoname") & "," & recSelect.Fields("photoname1") & "," _
& recSelect.Fields("hjudge") & ",#" & CStr(Format(recSelect.Fields("sdatetime1"), "yyyy-mm-dd hh:mm:ss")) & "#)"你把这一串负值了以后,msgbox一下就知道有没有问题了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货