A few things you can try:

1. Is it possible that the recordest is empty?
2. Is it possible that the recordset contains 65536 records?
3. Are any of the fields in the recordset strings, and if so are they 255
characters long?

"marko" wrote:

I am trying to retrieve data from a query in an Access 97 database and
populate Sheets in an Excel 2002 workbook using 'CopyFromRecorset'.

The problem i am having is that 2 out of the 7 Sheets (all sheets are being
populated one after the other within the same piece of code) are creating the
'Method 'CopyFromRecordset' of object 'Range' failed' error message and i
can't understand why? (If it was something to do with my programming sure all
sheets would fail!!)

Has anyone else come across this problem? If so, is there an answer to it?

Any help will be greatly appreciated

Mark