I'm getting a run-time error '-2147217833(80040e57)' String or binary data would be truncated. Any ideas what is going on here? It was working fine until another SQL Call was added to a second form within the excel worksheet. I did remove it but still getting this error so I'm currently STUCK. Your help and assistance is greatly appreciated and NEEDED.
http://www.vbforums.com/showth…ror&p=5096457#post5096457
Code
objMyCmd.CommandText = strSQL
objMyCmd.CommandType = adCmdText
Set objMyRecordset.Source = objMyCmd
If Err.Number = 0 Then
objMyRecordset.Open
If Not (objMyRecordset Is Nothing) Then
If (objMyRecordset.State And adStateOpen) = adStateOpen Then
objMyRecordset.Close
Set objMyRecordset = Nothing
End If
End If
End If
[COLOR=#333333][/COLOR]
Display More