0

I have tried Microsoft.Jet.OLEDB.4.0 and Microsoft Text Driver and both of these or not standard. I am trying to copy and paste simple sql from our database to these text drivers but i must heavily modify the sql to make it work. I am querying csv and text files. is there anything out there that can handle simple sql queries besides the drivers mentioned above?

Here is a sample of the sql i am working with:

select distinct 
     CASE F1
     WHEN 'a' THEN 'abcd'
     WHEN 'b' THEN 'bcde'
     WHEN 'c' THEN 'cdef'
     WHEN 'e' THEN 'efgh'
     ELSE 'Unkown'
     END AS Alpha1,
     CONCAT('91a',trim(F2)) as Alpha2
from 1.csv    
where trim(column1) IS NOT NULL
Luke101
  • 63,072
  • 85
  • 231
  • 359
  • Can you give an example of your seemingly "simple" query? Querying text-based data is fundamentally different from querying a database. – mellamokb May 23 '12 at 16:51
  • Hi I have posted a sample of the sql – Luke101 May 23 '12 at 17:03
  • Maybe you should Load the csv file into a real database (SQL server express maybe) and run your query on that; if that is in option in your environment. – Christian.K May 23 '12 at 17:15
  • Unfortunately, I am only a regular user and not part of IT. So i cannot use a real sql server. – Luke101 May 23 '12 at 17:21
  • Can you use MS Access? What about SQL Express? or SQL Lite and SQL CE, which don't even have to be installed? – mellamokb May 23 '12 at 19:18
  • I can use all except sql express. Since i am not an admin on the computer these technologies will not work in sharpdevelop. – Luke101 May 23 '12 at 20:51

0 Answers0