Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Catastrophic Failure" error using ADO to query Excel Workbook...
Hi,
I am using ADO and OLE DB to read an Excel range from a closed workbook into a recordset that I then dump into my worksheet using the CopyFromRecordset method. This is similar to the methods explained on Ron De Bruins site (http://www.rondebruin.nl/ado.htm) - and even his samples do not work on my Windows XP / Office 2003 machine. Strangely enough, Rons samples work fine on my Windows 2K machine with office 2003. But on my main dev machine (Win XP / Office 2003) I get this "catastrophic failure" error. Is there some change in the drivers between Windows 2000 and Windows XP that prevents this working - and how do I get it to work? Should I reinstall the latest MDAC? thanks for any help Philip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Catastrophic Failure" error using ADO to query Excel Workbook...
Hi Philip
Must work OK Do you have any missing references in the VBA editor Alt F11 ToolsReferences -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Philip" wrote in message ... Hi, I am using ADO and OLE DB to read an Excel range from a closed workbook into a recordset that I then dump into my worksheet using the CopyFromRecordset method. This is similar to the methods explained on Ron De Bruins site (http://www.rondebruin.nl/ado.htm) - and even his samples do not work on my Windows XP / Office 2003 machine. Strangely enough, Rons samples work fine on my Windows 2K machine with office 2003. But on my main dev machine (Win XP / Office 2003) I get this "catastrophic failure" error. Is there some change in the drivers between Windows 2000 and Windows XP that prevents this working - and how do I get it to work? Should I reinstall the latest MDAC? thanks for any help Philip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Catastrophic Failure" error using ADO to query Excel Workbook
Hi,
I re-registered 'C:\WINDOWS\System32\msexcl40.dll' in the registery Editor and now at least your examples work, so I am hopeful that was the problem ... and so far it seems to work with my CSV and MS Excel ones too (I have outrageous UNION and GROUP BY queries against multiple worksheets in multiple workbooks and csv files going on ... I won't ruin your day with the details!) I got the solution after seeing another error message about 'Could not find installable ISAM' so thanks anyway ! Philip "Ron de Bruin" wrote: Hi Philip Must work OK Do you have any missing references in the VBA editor Alt F11 ToolsReferences -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Philip" wrote in message ... Hi, I am using ADO and OLE DB to read an Excel range from a closed workbook into a recordset that I then dump into my worksheet using the CopyFromRecordset method. This is similar to the methods explained on Ron De Bruins site (http://www.rondebruin.nl/ado.htm) - and even his samples do not work on my Windows XP / Office 2003 machine. Strangely enough, Rons samples work fine on my Windows 2K machine with office 2003. But on my main dev machine (Win XP / Office 2003) I get this "catastrophic failure" error. Is there some change in the drivers between Windows 2000 and Windows XP that prevents this working - and how do I get it to work? Should I reinstall the latest MDAC? thanks for any help Philip |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Catastrophic Failure" error using ADO to query Excel Workbook
Thanks for posting back with the fix
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Philip" wrote in message ... Hi, I re-registered 'C:\WINDOWS\System32\msexcl40.dll' in the registery Editor and now at least your examples work, so I am hopeful that was the problem ... and so far it seems to work with my CSV and MS Excel ones too (I have outrageous UNION and GROUP BY queries against multiple worksheets in multiple workbooks and csv files going on ... I won't ruin your day with the details!) I got the solution after seeing another error message about 'Could not find installable ISAM' so thanks anyway ! Philip "Ron de Bruin" wrote: Hi Philip Must work OK Do you have any missing references in the VBA editor Alt F11 ToolsReferences -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Philip" wrote in message ... Hi, I am using ADO and OLE DB to read an Excel range from a closed workbook into a recordset that I then dump into my worksheet using the CopyFromRecordset method. This is similar to the methods explained on Ron De Bruins site (http://www.rondebruin.nl/ado.htm) - and even his samples do not work on my Windows XP / Office 2003 machine. Strangely enough, Rons samples work fine on my Windows 2K machine with office 2003. But on my main dev machine (Win XP / Office 2003) I get this "catastrophic failure" error. Is there some change in the drivers between Windows 2000 and Windows XP that prevents this working - and how do I get it to work? Should I reinstall the latest MDAC? thanks for any help Philip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel "data base engine failure"? | Excel Worksheet Functions | |||
"Web Query" refresh failure | Excel Discussion (Misc queries) | |||
System Error &H8000FFFF (-2147418113). Catastrophic Failure | Excel Programming | |||
Connection to MySQL causes "Catastrophic failure" | Excel Programming | |||
vba weird messages - "catastrophic failure" | Excel Programming |