Excel DB: Operation must use an updateable query

Question

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 updateable query" exception.

here s the code:

        String url="jdbc:odbc:Sample";   //CHANGE THE DATABASE NAME
        Connection conn= DriverManager.getConnection(url,"","");
        PreparedStatement prepstat = null;
        String insert="INSERT INTO [Sheet1$] ([AccountID], [ProjectID], [PositionID]) VALUES (?,?,?)";
        prepstat= conn.prepareStatement(insert);
        prepstat.setString(1, accountID);  
        prepstat.setString(2, projectID);
        prepstat.setString(3, positionID);
        prepstat.executeUpdate();   // this is where the exception occurs

Fionnuala · Accepted Answer · 2011-02-17 10:57:15Z

5

Did you specifically state that the connection was readwrite in your connection string?

I am not familiar with JDBC, but ODBC would be:

"Driver={Microsoft Excel Driver (*.xls)};" & _
"DBQ=C:\MyFolder\MyWorkbook.xls; ReadOnly=False;"

Excel is read-only by default: http://support.microsoft.com/kb/257819

edited Feb 17, 2011 at 10:57

answered Feb 17, 2011 at 10:51

Fionnuala

91.5k7 gold badges121 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Fionnuala Over a year ago

@amalbose I have added a note that I hope will help.

sunya · Accepted Answer · 2012-12-24 13:02:12Z

0

It was just needed to uncheck the read only while creating the DSN.

answered Dec 24, 2012 at 13:02

sunya

534 bronze badges

Collectives™ on Stack Overflow

Excel DB: Operation must use an updateable query

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related