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.

PowerShell script to generate a SQL CREATE TABLE statement from Excel files, with automatic column type detection and header handling. Convert Excel (.xlsx) files to pipe-delimited TXT files, ...

You use Office Excel 2010, the spreadsheet software from Microsoft, to create complex documents that can contain tables. Access 2010, the database software from Microsoft, also contains tables. If you ...