CopyFromRecordset Fails
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?
|