CopyFromRecordset method causing error

[colofnature]

Hi

Trying to dump a table into Excel using CopyFromRecordset, but it's only copying the first dozen rows, then breaking halfway through the next with the error message "Run-time error '-2147467259 (80004005)' Method 'CopyFromRecordset' of object 'Range' failed", which doesn't really tell me much. I could loop through the recordset to output each field individually but I'd rather know why it's not working. Any ideas?

Cheers
Col

 

[ted.martin]

Can you use the Docmd.Outputto code or macro?

 

[boblarson]

Just a thought, but could it be erroring out because it is trying to copy nulls?