Creating a database as you've described is a lot of work, and as others have mentioned their might be better alternatives than a relational database. (or at least the typical structure for a ...

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.

How to Use SQL Statements in MS Excel. With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations.

Instead of just importing static snapshots of your database information into Excel, SaveToDB allows you to directly connect to live databases like SQL Server, Oracle, MySQL, and many more.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks.

How Excel makes a relational database Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of ...

Start by opening a new Excel workbook and clicking on the cell where you want the database information you will be downloading to begin. Then click on Data, Import External Data ( exhibit 1 ) and ...