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....

Run a query against the Access database, then just filter it. You can see any values then.

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