Excel spreadsheets are fantastic bits of kit, but databases are not. Rather than making the full jump to replacing Excel with a database system, there is a halfway house you can consider.

If you don't have one, see Create your first SQL database to get a database with sample data up and running in a few minutes. In this article, you'll import sample data into Excel from that article, ...

[!INCLUDE SQL Server Windows Only - ASDBMI] In the [!INCLUDE ssMDSshort] [!INCLUDE ssMDSXLS], delete a row of data (a member) from the MDS repository when you no longer want it to be available to ...

What is SaveToDB add-in? For those unfamiliar, SaveToDB is a powerful and user-friendly add-in for Microsoft Excel that unlocks essential database features right in your spreadsheet program.

When you need to delete records based on a single value in Microsoft Excel, use this Visual Basic procedure. It can make your life a lot easier.