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....
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
No Sir,
The databse is confidentital. mangers only using the excel.
we need to vab code to extract data sir.
Please help...
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
Reply With Quote
