Re:Excel and SQL
by reeses on Thursday May 23, 2013 @05:35PM
(#5759672)
Pre-SQLite, I used the Excel OLEDB provider for a simple data store. Basically, each sheet is a table, and once you have a connection, you can run SQL against the workbook. "SELECT * FROM [People]" works mostly as expected, and ranges can be specified like "SELECT [People$A] FROM [People$A2:Y314]"
[ Parent
| on HN ]
There are no comments on this comment yet.