When using Team Foundation Server & Visual Studio - you can export data from the TFS database to excel, modify the values, and click "publish" to send the new values back to the database.
So, excel becomes a way to view and modify your database table.
The feature works surprisingly well and I'd like to use for other databases we have.
Anyone know how to program something like this with your own database? Or, possibly even the real name for this capability so I know what to call it?