excel « Operation « Java Database Q&A

1. Excel DB: Operation must use an updateable query    stackoverflow.com

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 ...

2. Insert huge data into database through excel    stackoverflow.com

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 ...

3. Update data to excel    coderanch.com

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).]

4. How to insert data from file excel into DB?    coderanch.com

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 ...

5. Using JDBC to insert into MS Excel file    coderanch.com

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 ...

7. Generating SQL Insert scripts from Excel sheet    coderanch.com

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 ...

9. Insertion in MS EXCEL    coderanch.com

10. How to INSERT records into Excel File using JDBC    coderanch.com

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

11. How to insert data into excel file using java code?    coderanch.com

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 ...

13. inserting values in the Excel sheet    coderanch.com