A reader asked what program I’d recommend for creating a “database” of her CD collection that could be broken down by song title, artist, genre, performance date, etc. A “database” is a “table” of ...

Flexibility and ease of use have made the spreadsheet the popular but unfortunate choice for makeshift databases; we can do better For a long stretch of early personal computing history, three ...

eSpeaks’ Corey Noles talks with Rob Israch, President of Tipalti, about what it means to lead with Global-First Finance and how companies can build scalable, compliant operations in an increasingly ...

I was just thinking about this: fundamentally, what is the difference between a spreadsheet file with many sheets (technically, isn't it a relational database?) and an SQL DB?<BR><BR>There has to be ...

Much of the early success of consumer electronics giant Apple Inc. was due to the demand of businesses for the Apple II home computer to run the VisiCalc spreadsheet software application. VisiCalc and ...

I'm working with a Mac-centric non-profit that has accumulated a list of 12k contacts in an excel spreadsheet. They would like to convert it to a database. I'm looking for suggestions to do so. The ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

If you have lots of spreadsheets you would like to analyze, but unfortunately don’t have the time to invest in trawling through each one to any great depth, but known they contain a wealth of valuable ...