Extracting data from Access - error encountered

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am extracting data from Access using an ADODB connection, and I've been
having no problems with it for most times that I run it.

But for one time period that I'm running, on this line

Range("A1").Offset(1, 0).CopyFromRecordset Recordset

I get this error

"Automation error - unspecified error"

Yet it still does the copy (I think correctly). So I could just bounce this
back up from the error handler, but I'm concerned that it happened at all.

Any advice appreciated, and of course, if I have not provided enough
information, feel free to berate me and request more...

Thanks
Daniel
 
There are various error collections you could check from ADODB. Use the
Object Browser to the objects.
Also there are Excel's error collections:
Application.OLEDBErrors
Application.ODBCErrors

However, as you get it on .CopyFromRecordset rather than creation of the RS,
it may have something to do with incompatible values in the RS.

NickHK
 
Thanks Nick

NickHK said:
There are various error collections you could check from ADODB. Use the
Object Browser to the objects.
Also there are Excel's error collections:
Application.OLEDBErrors
Application.ODBCErrors

However, as you get it on .CopyFromRecordset rather than creation of the RS,
it may have something to do with incompatible values in the RS.

NickHK
Click to expand...
 
Back
Top