Results 1 to 3 of 3
  1. #1
    David Cristallo

    Querying Access db from Excel

    Hi there,

    I'm new to Access and my question is probably stupid:
    Let's say, I've got one access table, tblCountries, with a list of countries and their associated abbreviation and ISO code. From Excel, I would like to retrieve, for a given country abbreviation, the corresponding ISO code. Is it possible to retrieve this information without using a recordset to store the returned ISO code ?


  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Querying Access db from Excel

    What version of Access and Excel are you using? You can run a query that returns only a single value. Is the Access database linked to the Excel worksheet or are you trying to create a remote connection with ADO?

  3. #3
    David Cristallo

    Re: Querying Access db from Excel

    Sorry Charlotte,

    I was not clear enough: I need to use the DAO technology as my project will be run in Office97 under Windows NT4. To clarify my question: I would like to know if I can query Access from Excel to retrieve a single value without using a recordset object. Is it possible to execute a SQL query from Excel that would return a single value ? If so, could you please point me in the right direction ?


Posting Permissions

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