How to View column field from Acess Database in listview ( Listbox)

[shabbir]

Hi All , I have Data in Access Database,

Access Database feilds are , Month, Week,Emp ID,Name,......Performance , Attandence, Quality, C-Sat,Accuracy ......for 1 Year.Now I want to show this Data in Excel user form( using ListView) , If user enter Emp ID then should get all details of respective employee. I need help how I can start this.

[Lalit_Mohan]

Hi Shabbir,

First take a field name and run query through recordset then

listview.list = recordset.getrows

that's it..

[shabbir]

Thanks Lalit

I will check and let you know if face any problem