Consulting

Results 1 to 4 of 4

Thread: Get Data From Acess

  1. #1

    Get Data From Acess

    hello All,

    Gud Day !!!

    This is my 1st Post.

    I have data base in my c:/

    Data base name : age.mdb
    Table name : consolidation
    Field Name : team, salary,year

    I have excel file. in that excel file sheet1 a1= team & a2= year.

    based on the valu i want to extract data from the datbase.

    please help to provide the VBA code for that.

    Thank you....

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,264
    Location
    Run a query against the Access database, then just filter it. You can see any values then.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    No Sir,

    The databse is confidentital. mangers only using the excel.

    we need to vab code to extract data sir.

    Please help...

  4. #4
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    There is an example here
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

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