Cover by Joel Spolsky

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

O'Reilly logo

Rory BlythEXCEL AS A DATABASE1

Just wait until you find out that your corporate firewall strips the pictures from incoming email.Ed.

As a developer, you've probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of "data" by someone in marketing and been told to "do something with it."

Columns probably didn't line up, and a thousand different fonts were used. Every feature of Excel was probably abused and abused again to avoid having to use an actual database application for storage of the data.

Of course, it's up to you to make sense of the layout, and marketing could just give a bleepity-bleep about what a pain it is to suck weird data out of Excel and ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required