Hi Ron

Thanks a lot for the link. I have gone through a exceltips.com and
wrote a similar program but did not get through. Now I faced another
problem . I am writing a VB appication in which I have a populate the
combo box with distinct values of a particular field. The project
started showing errors when i manually copied and pasted the record
from excel sheet to access database. The data base is getting connected
and the record set is also giving count. When it comes to Add Item of
combo box , The value is shown as null. Awaiting help if you could do.

Thanx
Anuradha.


--
anuradha
------------------------------------------------------------------------
anuradha's Profile: http://www.excelforum.com/member.php...o&userid=25348
View this thread: http://www.excelforum.com/showthread...hreadid=388329