View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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?