ODBCErrors Object

Remarks

Each ODBCError object represents an error returned by the most recent ODBC query. If the specified ODBC query runs without error, the ODBCErrors collection is empty. The errors in the collection are indexed in the order in which they're generated by the ODBC data source. You cannot add members to the collection.

Example

Use the ODBCErrors property to return the ODBCErrors collection. The following example refreshes query table one and displays any ODBC errors that occur.

With Worksheets(1).QueryTables(1) .Refresh Set errs = Application.ODBCErrors If errs.Count > 0 Then Set r = .Destination.Cells(1) r.Value = "The following errors occurred:" c = 0 For Each er In errs c = c + 1 r.offset(c, 0).value = er.ErrorString r.offset(c, 1).value = er.SqlState Next Else MsgBox "Query complete: all records returned." End If End With 

See also:

• Excel Object Model Reference
• ODBCErrors Object Members