VBA to Retrieve data from Access database based on formula

  • Hi, I am pretty new to this . I want to write a VBA/macro in excel that will retrieve data from Microsoft Access. Following things i have to do in my program.
    1.I want to create custom formula in excel using VBA.
    2. Based on that formula I want to retrieve data from Access.


    I have uploaded a sample file .


    If any body know I shall be very thank full to you guys.
    Thanks in advance.

  • Re: VBA to Retrieve data from Access database based on formula


    How you expect anyone to answer this when you give absolutely no information about the formula or database is beyond me.


    This thread is locked. Feel free to start another thread explaining your problem fully in the first post. After fully explaining everything about the formula and the database (location, structure, user ID and password if needed - not forgetting the exact parameters for the SQL statement) please include the following,edited, statements from your initial message.


    Quote

    1.I want someone else to create custom formula in excel using VBA.
    2. Based on that formula I want someone else to retrieve data from Access.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!