Results 1 to 2 of 2

Thread: CopyFromRecordset - Access to Excel Woorksheet

  1. Apr 8th, 2005, 05:41 AM #1
    bjso
    bjso is offline

    Thread Starter
    Junior Member
    Join Date
    Sep 2004
    Posts
    16

    CopyFromRecordset - Access to Excel Woorksheet

    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
    Reply With Quote Reply With Quote
  2. Apr 8th, 2005, 06:14 AM #2
    Ecniv
    Ecniv is offline
    Don't Panic! Ecniv's Avatar
    Join Date
    Nov 2000
    Location
    Amsterdam...
    Posts
    5,343

    Re: CopyFromRecordset - Access to Excel Woorksheet

    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

    BOFH Now, BOFH Past, Information on duplicates

    Feeling like a fly on the inside of a closed window (Thunk!)
    If I post a lot, it is because I am bored at work! ;D Or stuck...
    * Anything I post can be only my opinion. Advice etc is up to you to persue...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width