Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Location
    USA, Georgia, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using DFunctions with MSQuery Data in Excel (2000)

    I am trying to reduce the size of a workbook by moving a 4500 record database into Access (with 10 fields), and then using MSQuery to pull only the 2 fields I need (still all 4500 records) into Excel. The problem I'm running into is that I can't seem to successfully reference the new database in Excel using the DFunctions (specifically DGET). I have named the collection of cells that the query was put into, and used that name in the DGET function as the database name, but still nothing.

    Thanks!
    Pam

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using DFunctions with MSQuery Data in Excel (2000)

    Do you get an #ERR or #VALUE in the cell, or something else?

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Location
    USA, Georgia, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using DFunctions with MSQuery Data in Excel (2000)

    I get a #VALUE error. I've checked that there are, in fact, entries in the database for the criteria I'm calling against, and that there are not duplicate entries.

    Thanks,
    Pam

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using DFunctions with MSQuery Data in Excel (2000)

    Did you include the header row (with the field names) in the named range? Excel needs those to be able to interpret the field and criteria arguments.

    By the way, if you used MS Query, chances are that the imported range was assigned a name automatically (on my system, it is 'Query_from_Access'); you can use that name in the formula.

Posting Permissions

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