Conclusion We've covered a lot of ground in a very short space in this chapter. We've explained what databases are and under what circumstances you should use them. We've explained how to structure your data properly for storage in a relational database. We've provided a brief introduction to SQL and ADO and demonstrated how you can use them to retrieve and manipulate data in a relational database from your Excel VBA application. Because we cannot possibly do justice to any of these topics in a single chapter, we've also provided you with pointers to some excellent resources for additional information.The ability to work with databases may have been an optional skill for the professional Excel developer five or six years ago. Today it is an absolute requirement. As different types of applications converge, there are fewer and fewer nontrivial Excel applications that do not require interaction with a back-end database of some kind. If you need to be a true professional Excel developer, you will need to understand how to work with databases. |