+ Reply to Thread
Results 1 to 4 of 4

VBA - query an Access table -> results in Excel

  1. #1
    rirus
    Guest

    VBA - query an Access table -> results in Excel

    Using VBA, I want to query an Access database table which has > 240,000
    records. The data I am quering for is from a worksheet (sheet1) and I would
    like the results stored in an Excel worksheet (sheet2). The results from the
    query will be only a few thousand records, never greater than 10,000. The
    Access db and Excel sheet are on the same PC. Eventually I will need to query
    the Access DB from a different PC across a network.
    What is the best way to do this?

    Thanks,

    rirus

  2. #2
    Dave Patrick
    Guest

    Re: VBA - query an Access table -> results in Excel

    I'd use ADO This article may help.

    http://support.microsoft.com/kb/257819/

    --

    Regards,

    Dave Patrick ....Please no email replies - reply in newsgroup.
    Microsoft Certified Professional
    Microsoft MVP [Windows]
    http://www.microsoft.com/protect

    "rirus" wrote:
    | Using VBA, I want to query an Access database table which has > 240,000
    | records. The data I am quering for is from a worksheet (sheet1) and I
    would
    | like the results stored in an Excel worksheet (sheet2). The results from
    the
    | query will be only a few thousand records, never greater than 10,000. The
    | Access db and Excel sheet are on the same PC. Eventually I will need to
    query
    | the Access DB from a different PC across a network.
    | What is the best way to do this?
    |
    | Thanks,
    |
    | rirus



  3. #3
    Ron de Bruin
    Guest

    Re: VBA - query an Access table -> results in Excel

    Maybe you can use this
    http://www.rondebruin.nl/accessexcel.htm

    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "rirus" <rirus@discussions.microsoft.com> wrote in message news:668506FE-DDCA-4E01-9FB1-9CB236D47F7C@microsoft.com...
    > Using VBA, I want to query an Access database table which has > 240,000
    > records. The data I am quering for is from a worksheet (sheet1) and I would
    > like the results stored in an Excel worksheet (sheet2). The results from the
    > query will be only a few thousand records, never greater than 10,000. The
    > Access db and Excel sheet are on the same PC. Eventually I will need to query
    > the Access DB from a different PC across a network.
    > What is the best way to do this?
    >
    > Thanks,
    >
    > rirus




  4. #4
    rirus
    Guest

    Re: VBA - query an Access table -> results in Excel

    I set up an ODBC for the Access database and then added a tablequery in the
    Excel worksheet. So far that is working great and is getting what I need.
    Surprisingly, the query takes seconds to run which is faster than what I
    expected. I am not sure though how it will work across a network. Hopefully
    the retrieval rate will not change too much.

    Thanks for your inputs. They have been helpful.

    rirus


    "Ron de Bruin" wrote:

    > Maybe you can use this
    > http://www.rondebruin.nl/accessexcel.htm
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "rirus" <rirus@discussions.microsoft.com> wrote in message news:668506FE-DDCA-4E01-9FB1-9CB236D47F7C@microsoft.com...
    > > Using VBA, I want to query an Access database table which has > 240,000
    > > records. The data I am quering for is from a worksheet (sheet1) and I would
    > > like the results stored in an Excel worksheet (sheet2). The results from the
    > > query will be only a few thousand records, never greater than 10,000. The
    > > Access db and Excel sheet are on the same PC. Eventually I will need to query
    > > the Access DB from a different PC across a network.
    > > What is the best way to do this?
    > >
    > > Thanks,
    > >
    > > rirus

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1