Is the above possible? Lets say I wanna create a database for employees with their information, will I be able to write a programme in VBA or is there any other better solution?

yes, everythin is possible in this field. you have to understand how to work or acess onjects (in this case and excel spreadsheet) and be able to manipulate them. its almost the same as working with access only that there is a bit of math when it comes to accessing the rows and columns. if your project requires you to do some calculations then you can go for it but i'd suggest you just use ms acess if its only a database application. God Reigns

Actually its a lot easier with Access as access is a databse application and has functions specificaly for manipulating data. not least of all SQL. You have a choice between using DAO or ADO. DAO is simple and for a flat file databse, faster. ADO is a little more complex but is more suited if you are creating a muti-user application. All the infoermation you need to use DAO or ADO is in the help files. Stuart

Actually it is easier using Access as Access has facilities specifically for manipulating data, not least of all SQL. You have the choice of either using DAO or ADO. With a flat file database, DAO is simpler and faster. ADO is a bit more complex and is better if you are creating a multi-user application. All the information required to use DAO and ADO is in the help files. Stuart