>Every once in a while we have a problem with Excel's DAO copyfromrecordset() method when it's called from ACCESS.
>
>It simply does not copy anything.
>
>I was already able to solve the problem by reinstalling mdac, but that was under windows 98. How do I solve this under W2K?
>
>TIA
>
>Marc

What version of Excel? Beginning with Excel 2000, CopyfromRecordset() accepts either an DAO or ADO recordset. See this MSKB Q246335 HOWTO: Transfer Data from an ADO Recordset to Excel with Automation. HTH