Harry Whitehouse

Simon! Many thanks! What a bonehead move on my part! Now everything works beautifully! Harry

The code in the attached image shows a problem I'm hving with a very simple CSV file. I've tried various select statements with outputs shown. I'm having problems using the column names in the select statement. It appears that I have to specify the column name with single quotes around it. I can't seem to specify column names in a "SELECT ORDER,FIRSTNAME FROM HUANG" without syntax errors. Statemnts with WHERE clauses either give me syntax errors or incorrect reults. (See the code image for details)....

Simon- Thanks so much for this response.!!! You were absolutely correct! There were some unicode charactors which did not "show" in Ecllpse! This must have been introduced when I did a copy of the Mac file "Get Info" information screen (see image attachment). I figured I was mistyping the path and so I did a copy and paste from the Info screen. There were little "left arrows" between the path elements and I deleted them (or I thought I did) and replaced with '/'. Somehow the result was adding this...

This code throws a "directory not found" Connection c = null; try { Class.forName("org.relique.jdbc.csv.CsvDriver"); Properties props = new java.util.Properties(); props.put("fileExtension", ".csv"); // file extension is .cscv c = DriverManager.getConnection("jdbc:relique:csv:" + "‎⁨Users/harrywhitehouse/Desktop⁩", props); I've tried every permutation of separator that I could think of but with no luck. with leading /'s and ending '/s and double /'s. I've tried it with and without props. When I drag...