When integrating Excel, which VBA code will allow you transfer data from recordset xRec in Access directly onto a spreadsheet (xlws) in Excel.

xlws.range("A1").CopyFromRecordset xRec

Docmd.TransferDatabase xlws, xRec

Docmd.TransferSpreadsheet xlws, xRec

xlws.CopyFromRecordset xRec

Answer:
xlws.range("A1").CopyFromRecordset xRec

Note: This Question is unanswered, help us to find answer for this one