Excel VBA contains a reference library called Active Data Objects. This Library is very powerfull and can be combined with SQL to manipulate External database from within your excel workbooks. The following tutorials will show you everything you need to know to create powerfull database systems using excel as a front end platform.
All our tutorial samples are free however if you appreciate our work and would like to make a voluntary donation then please do.
Both the below books by John Walkenbach are fantastic books and he is a brilliant author, I would recommend picking one of these books up even if just for a reference. I have read power programming cover to cover and it is easy to follow and is a must have for any serious VBA programmer.
If you have read any books and feel they are worth recommending then please post about them on our Forum.