Re:Excel as a database
by tsewlliw on Monday April 08, 2013 @08:16PM
(#5515627)
I don't remember exactly how, but yeah, you can totally do that. Set up your DB as a data source or some such.
[ Parent
| on HN ]
Re:Excel as a database
by pixelcloud on Monday April 08, 2013 @08:18PM
(#5515645)
You can add many different data sources (any ODBC driver), access, sharepoint sites, etc. Its a pretty useful tool for people who are not programmers and rely on PivotTables and such.
Its surprising how effective excel can be for non-programmers.