The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

With this new relational database/table feature, this process is so easy that once it’s set up in Excel, you can extract specific data and create dozens of reports in minutes. PCWorld helps you ...

When you use MySQL to query a database, you have the ability ... Use those modifiers with any MySQL query to create tab-delimited files that Excel can open. After loading the data into Excel ...

Fortunately, you can use Excel macros to automate some of these tasks and save yourself some hassle. In this article, you'll learn how to create and run simple macros that can update database ...