Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am writing a query to populate an excel sheet in the same way that I
have in many occasions in the past: 1) open the db using DAO 2) run the query with OpenRecordset 3) transpose the array and paste it into the sheet When I attempt this today, I get: Run Time Error 3343 - Unrecognized database format: Looking around on the 'net, this appears to suggest db corruption. However, the db repairs/compresses almost instantly and reports no errors. It can be used problem-free. I have a reference to MS DAO 2.5/2.51 in Excel's References. Perhaps this is too old, but I can't seem to find a newer one in the Available References list. Anyone have any ideas here? Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unrecognized format. | Excel Discussion (Misc queries) | |||
Excel 2007 unrecognized file format in Excel 2003 More options | Excel Discussion (Misc queries) | |||
Unrecognized format | Setting up and Configuration of Excel | |||
Error of old type library or unrecognized HRESULT | Excel Programming | |||
Format -Time Error on Excel 97 | Excel Programming |