November 25, 2003 tools

ADO.NET CsvFileTester

CsvFileTester is a tool inspired by Shawn Wildermuth’s ExcelFileTester, which he wrote cuz I kept asking him how to do queries on .xls files. However, because the Excel query language has no where or order by clauses, I gave that up in favor of comma-separated text files.

I wrote CsvFileTester (with Shawn’s help) to explore the ADO.NET/ODBC/JET support for CSV files and I was amazed at how comprehensive the support was. And, since I can never remember the syntax and limitations between one use of Jet expression syntax and the next, I put a bunch of samples in the combobox.