Report Offensive Message

Excel as a Database
Whilst I would agree with the general principle, there are occasions when this is useful. I have worked in schools and staff often feel comfortable with Excel but wary of databases.
It was often useful to allow them to formulate their data in Excel and support them in converting the Excel file to Access. As well as their comfort this encourages staff to structure their data collection more efficiently - particularly when you demonstrate data mining that they had never anticipated! Excel also has native import/export - almost unlimited formats to interface with many tailored SQL systems.
Posted by rjfandre
27th Jun 2011