for a jdbc program, im required to make a connection an excel database. the connection is successfully made but wen entering values into it, its giving an "Operation must use an ...
I have a requirement to insert a huge data from excel file with more than 100,000 records.
What is the best way to do this?
My idea is to read 500 rows and ...
Thanks! for the reply.I did a search.Btt,the topic included only retreival of data from excel.I want to know how to insert, update and delete data to excel using jdbc.Please , suggest me options where i can find this information. Thanks [This message has been edited by Naresh Babu (edited March 24, 2001).]
Well, you could create an ODBC driver to your Excel file and read and write data that way (using the JDBC-ODBC Bridge). Also, depending on the database, there may already be conversion utilities available (Access and SQL Server have such utils (them being M$), but I think other DBs do as well...) [ November 19, 2003: Message edited by: Joel McNary ...
I haven't used JDBC to access Excel files, but the only thing that I can see that would certainly cause a problem is if the result String contained a single-quote itself, breaking your quoting. For example, "This doesn't work" would cause confusion since the ' in doesn't would terminate the quoting for result. Otherwise, my only recommendation is to verify that ...
Parameswaran, If you just want to import the columns in a different order, you can often configure your database's import facility to do so. For something more complicated, you can write a script in any language that accesses the database. I'll assume you know Java since you are asking here. In Java, you would loop through the Excel spreadsheet and use ...
Dear Neeraj, Thanx for your reply. Let us assume that i use separators also, I guess that will not automate the writing to excel file. It will be a plain text file. Also I need to find out how to write to different sheets of Excel file, how does one achieve that? Any idea? Regards Preeti
I wrote below code to fetch data from excel work sheet. It is working file. import java.io.*; import java.sql.*; public class ExcelReadTest{ public static void main(String[] args){ Connection connection = null; try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection( "jdbc:odbc:exceltest" ); Statement st = con.createStatement(); ResultSet rs = st.executeQuery( "Select * from [Sheet1$]" ); ResultSetMetaData rsmd = rs.getMetaData(); int numberOfColumns = rsmd.getColumnCount(); while ...