View Full Version : Get Data From Acess

06-10-2010, 05:27 AM
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....

Bob Phillips
06-10-2010, 05:37 AM
Run a query against the Access database, then just filter it. You can see any values then.

06-10-2010, 05:52 AM
No Sir,

The databse is confidentital. mangers only using the excel.

we need to vab code to extract data sir.

Please help...

06-10-2010, 01:35 PM
There is an example here (http://www.vbaexpress.com/kb/getarticle.php?kb_id=889)