+ Reply to Thread
Results 1 to 2 of 2

Retrieve data from Access

  1. #1
    Registered User
    Join Date
    02-12-2007
    Location
    In the world
    Posts
    4

    Retrieve data from Access

    Now I will try to be clear about my issue :

    First example :
    Imagine you have a table into one Access database called "Customers"
    Inside this table you have many records with several fields
    One of these fields is the name of the customers
    One of these fields is the address of the customers

    IŽd like to return to an Excel Worksheet the address of a specific customer inside this Access table using a function (UDF)

    Note that I need to specify in the worksheet:
    - the path where this database is located
    - the name of the database
    - the name of the table
    - the name of the fields involved to return the address of a specific customer

    Second example :

    Now imagine you have a table into one Access database called "Sales"
    Inside this table you have many records with several fields
    One of these fields is the name of the customers
    Another field is the period of the sales occured (month)
    Another field is the amount of sales

    IŽd like to return to an Excel Worksheet the amount of sales of a customer in one specific month using a function (UDF)

    Note that I need to specify in the worksheet:
    - the path where this database is located
    - the name of the database
    - the name of the table
    - the name of the fields involved to return the sales of a customer in one specific month

    I imagine one function like this (although I do not know how to do it)

    ImportAccessData(A1;A2;A3;A4:A5)

    Where :
    A1=the path where the Access database is located
    A2=the name of the Access database
    A3=the table name
    A4:A5=the range where the criteria will be input (this range must include in the first line all the field names and in the second line the records which will define the information required)

    Note that I only want return one specific information to store in one cell of the Worksheet. I do not want to link the entire table to the Worksheet.

    Any additional explanations do not hesitate to ask me.

    Thanks,

    Ilmo

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    To master data import from Access ...
    http://www.fontstuff.com/access/index.htm
    and
    http://www.bygsoftware.com/Excel/SQL/UsingSql.html
    Last edited by Carim; 02-13-2007 at 09:33 AM.
    HTH
    Carim


    Top Excel Links

+ 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