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