hey all,

here's the thing my colleague needs to append a database from a excel file (having same structure/headers). For eg. if i already have a database with following fields :

Name, EMP_ID, City, Position

along with some data already in it & let's say i need to add new data every week/month , is there any way i can do this @ run time using VB 2005?

Let's say i format my excel sheet similar to db structure & place it @ a common location & then with a click of a button Vb would import the excel sheet data into my databse...