Bhuvana

Resolved it.. Thanks

Got it.. Thanks.

Thank u. But how can i mention the path of the new csv file in CsvDriver.writeToCsv() ? Pls help

Hi Simon , I mean column name space in WHERE clause and not in Select like below, ResultSet results = stmt.executeQuery ("Select * from sample where FIRST NAME = 'ABC' "); When I execute this stmt im getting below error, Syntax error: Encountered " <name> "NAME "" at line 1, column 49. Was expecting: <eof> </eof></name>

Thanks and i have changed it. Now Im getting "Expected separator at line and position" error message. And I have tried using this "0x09" too. Class.forName("org.relique.jdbc.csv.CsvDriver"); Properties props = new Properties(); props.put("suppressHeaders", "false"); props.put("escapeSeparatorInQuotes", "false"); Connection conn2 = DriverManager.getConnection("jdbc:relique:csv:path?separator=\t"); Statement stmt2 = conn2.createStatement(); ResultSet rs = stmt2.executeQuery("SELECT * FROM Sample");...

And I have tried using "0x09" option as well

Thanks and i have changed it. Now Im getting "Expected separator at line and position" error message. Pls advise. Class.forName("org.relique.jdbc.csv.CsvDriver"); Properties props = new Properties(); props.put("suppressHeaders", "false"); props.put("escapeSeparatorInQuotes", "false"); Connection conn2 = DriverManager.getConnection("jdbc:relique:csv:path?separator=\t"); Statement stmt2 = conn2.createStatement(); ResultSet rs = stmt2.executeQuery("SELECT * FROM Sample"); boolean append = true; CsvDriver.writeToCsv(rs,...