1. Excel DB: Operation must use an updateable query stackoverflow.comfor 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.comI have a requirement to insert a huge data from excel file with more than 100,000 records. |
3. Update data to excel coderanch.comThanks! 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.comWell, 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.comI 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 ... |
6. export the data retrieved through a query into excel coderanch.com |
7. Generating SQL Insert scripts from Excel sheet coderanch.comParameswaran, 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 ... |
8. Writing query results to an Excel sheet coderanch.com |
9. Insertion in MS EXCEL coderanch.com |
10. How to INSERT records into Excel File using JDBC coderanch.comDear 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.comI 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 ... |
12. update sql database using excel spreadsheet records coderanch.com |
13. inserting values in the Excel sheet coderanch.com |