Range to Recordset?

[cbhnp]

I know I can copy an ADO recordset to a range by using the CopyFromRecordset method. But is there a similar way to to do the reverse - get a range into a recordset? Or do I need to loop through the CurrentRegion with AddNew?

I'm trying to use Excel as an input form. Binding a datagrid control would be great but I don't see VBA being able to do that. Any suggestions would be great.