Pls help me in How to import Excel data into Ms Access suing VB code

You don't indicate whether you're importing into an existing table but you can use SQL for this. The following thread contains an ADO example but you can also use the SQL statement with DAO as well:

http://tinyurl.com/y5pgsp