OLEDBError.Number Property (Excel)
Returns a numeric value that specifies an error. The error number corresponds to a unique trap number corresponding to an error condition that resulted after the most recent OLE DB query. Read-only Long.
Syntax
expression .Number
expression A variable that represents an OLEDBError object.
Example
This example displays the error number and other error information returned by the most recent OLE DB query.
Set objEr = Application.OLEDBErrors(1)
MsgBox "The following error occurred:" & _
objEr.Number & ", " & objEr.Native & ", " & _
objEr.ErrorString & " : " & objEr.SqlState