Re:Execute SQL against structured text like CSV or TSV
by dmethvin on Tuesday February 04, 2014 @09:44AM
(#7177647)
Even better is LogParser, which lets you do SQL queries against just about any data format you'll find in a file on Windows. It's been around for a decade and continues to be improved.
http://technet.microsoft.com/en-us/scriptcenter/dd919274.asp...
Re:Execute SQL against structured text like CSV or TSV
by burmask on Tuesday February 04, 2014 @09:55AM
(#7177733)
Microsoft LogParser is not only an established utility, it's extremely fast, too.
Re:Execute SQL against structured text like CSV or TSV
by DEinspanjer on Wednesday February 05, 2014 @07:29AM
(#7183335)
I remember LogParser from years back. I used to be very involved in that nascent community, and I developed a plugin for it that let you parse an input file using a regex with capture groups so you could use SQL queries on log files that did not have records with simple delimited columns.
Re:Execute SQL against structured text like CSV or TSV
by userbinator on Tuesday February 04, 2014 @07:21AM
(#7176941)
Even older, the ODBC text driver for Windows 3.1x supported this, 20 years ago:
http://support.microsoft.com/kb/146220
Re:Execute SQL against structured text like CSV or TSV
by krapp on Tuesday February 04, 2014 @07:57AM
(#7177083)
Apropo of absolutely nothing, my advanced C++ final was a basic console CRUD application using ADO. It was a nightmare - fun, and I broke the database (and didn't get points for that) but a nightmare.
I'm so glad C# is a thing now.
Re:Execute SQL against structured text like CSV or TSV
by edgarvm on Tuesday February 04, 2014 @11:03AM
(#7178246)
For SQL Server OPENDATASOURCE and OPENQUERY can do the trick too
http://msdn.microsoft.com/en-us/library/ms974559.aspx
(article dated 2004)