Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting data from Access - error encountered
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting data from Access - error encountered
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extracting data from Access - error encountered
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/Match ... Excel has encountered an Error | Excel Discussion (Misc queries) | |||
Excel encountered an error | Excel Discussion (Misc queries) | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Extracting Excel data and uploading to access | Excel Programming | |||
Extracting Access data | Excel Programming |