Thanks Nick

"NickHK" wrote:

> 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
>
> "Daniel Bonallack" <DanielBonallack@discussions.microsoft.com> wrote in
> message news:F50F3564-9272-40AA-8444-80CA790238C7@microsoft.com...
> > 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
> >
>
>
>