I don't know about expressions, but this snippet is right out of the VBA help
file.

If the Recordset object contains fields with OLE objects in them, this
method fails.



"Bob" wrote:

Using Excel and Access 2003, the CopyFromRecordset method fails. I'm using a
DAO recordset and the OpenRecordset method. By a process of elimination, it
seems that fields in the Totals query that are Expressions are causing the
problem. Is it true that queries with Expression fields fail with
CopyFromRecordset?