Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    311

    Unanswered: Opening an Ado Record Set from access and inserting into excel range

    I would like to open an Ado Record Set from access and inserting into a range in my excel file. I know how to use ADO in access but not excel, can anyone help?

  2. #2
    Join Date
    Sep 2003
    Location
    Cincinnati, Oh USA
    Posts
    203

    Re: Opening an Ado Record Set from access and inserting into excel range

    To make life simple I would simply import the data from access using the menu options Data>Get External Data


    Originally posted by mikezcg
    I would like to open an Ado Record Set from access and inserting into a range in my excel file. I know how to use ADO in access but not excel, can anyone help?
    Rick Knight
    KnightShift Office Solutions and Horse Breaking
    VB, VBA, FileMaker, Access Solutions, Web Solutions

Posting Permissions

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