CopyFromRecordset - Access to Excel Woorksheet

[bjso]

Hi!

I want to dump the contents of my recordset into excel woorksheet.
The recordset rsData contains 50 rows.
Sheet1.Range("A1").CopyFromRecordset rsData

I now have data in cell "A1" to "A50"
The problem is I have other data in cell "A10", "A20" for example, which I dont want to overwrite.

Is it possible to skip some cells while dumping the contents of the recordset.
I want the the recordset in "A1":"A9", "A11":"A19" etc..

How do I do this without writing more than one Query?



Best regards

/Bjso

[Ecniv]

Can't see why you'd want to paste around other fields... Either paste at the bottom or on another sheet first then code a copy routine to put the data in rows which are free.

An option :)