CopyFromRecordset Excel Automation

B

Bob Barnes

Part of my Access-to-Excel Automation code includes...

objXLSheet.Range(strCellRef).CopyFromRecordset RS, 100, 4
where RS -->Set RS = CurrentDb.OpenRecordset(strSql, dbOpenSnapshot)

For some reason, this does not always work.

It will Error to...
Select Case Err
Case -2147417851 '"The server threw an exception"
' Caused when objXLSheet.Range(strCellRef).CopyFromRecordset RS

Is there alternate code to transfer the Access Recordset to EXcel via
Automation?

TIA - Bob
 
Top