3 ms·

So how about a tool that would open an Excel spreadsheet as a sqlite database ? By on-the-fly converting the tabs into tables. Then open this database in your f

by Gys 11y ago

So how about a tool that would open an Excel spreadsheet as a sqlite database ? By on-the-fly converting the tabs into tables. Then open this database in your favorite sqlite browser. Maybe even open several spreadsheet files at once, each file in a separate database.

batou 11y ago
ODBC does this on windows. You can connect to a spreadsheet and issue queries.
d4nt 11y ago
Neat idea, you could get pretty close to that experience right now by running http://databaseimportscriptor.com http://databaseimportscriptor.com, then Alt+Tab-ing into MySQL Workbench. Problem is, I can't really see a market for it. You're trying to write SQL on your database, so you're a developer, and how much would you really be willing to pay to have the experience streamlined down to a couple of clicks?