Seems some moron at Microsoft (read Product Manager) decided to depreciate this functionality in Excel 2007 in favour of using the worst data management application on the planet - MS Access.
Thankfully someone has come to our rescue with an Excel 2007 Add In.
http://msdn.microsoft.com/en-us/library/bb462636(v=office.11).aspx