ExcelBanter - CopyFromRecordset Fails

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - CopyFromRecordset Fails (https://www.excelbanter.com/excel-programming/427292-copyfromrecordset-fails.html)

Bob

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?

All times are GMT +1. The time now is 02:48 PM.