CopyFromRecordset Fails

B

Bob

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting from CopyFromRecordset 0
CopyFromRecordset fails if more than 911 byte in a field 0
Copying recordset multiple times using copyfromrecordset 5
ado copyfromrecordset and nextrecordset 4
CopyFromRecordset fails if string > 911? 4
Import multiple Access Queries 0
Start copying an access recordset starting with the next column 1
CopyFromRecordSet extremely slow 2

Top