yes it is good program.
import java.sql.*;
import java.io.*;
public class Rgupta31 {
public static void main(String[] args) {
try {
String newLine = System.getProperty("line.separator");
Writer output = null;
File file = new File("ExcelFile.csv");
output = new BufferedWriter(new FileWriter(file));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:schooldb");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select * from [Sheet1$]");
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
while (rs.next()) {
for (int i = 1; i <= numberOfColumns; i++) {
if (i > 1)
System.out.print(", ");
String columnValue = rs.getString(i);
System.out.print(columnValue);
output.write(columnValue);
output.write(newLine);
}
System.out.println("");
}
st.close();
con.close();
output.close();
} catch (Exception ex) {
System.err.print("Exception: ");
System.err.println(ex.getMessage());
}
}
}
regards,
phe9oxis,
