thnks for the code. but its not working.. may be i m doing some mistake
can you please give the code to insert record in the database.
i m new to the the database connectivity part

--
ashishpre
-----------------------------------------------------------------------
ashishprem's Profile: http://www.excelforum.com/member.php...fo&userid=3148
View this thread: http://www.excelforum.com/showthread.php?threadid=54520