Name

range.CopyFromRecordset([Data, MaxRows, MaxColumns])

Synopsis

Copies the contents of a Recordset object into the specified range.

Argument

Settings

Data

The Recordset object to copy.

MaxRows

If you do not want to copy all records, this argument specifies the maximum number of records to copy.

MaxColumns

If you do not want to copy all fields, this argument specifies the maximum number of fields to copy.

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial