How to set Password protection in excel using java

Dear Bamkin ,

I used your code and paste it in my program. The error is as the follow:

Code:

stmnt = c.createStatement();

String query = "select StudentNumber, Email, New_Email_Address from [Sheet1$] where Len(New_Email_Address) > 0";

System.out.println(query);

rs = stmnt.executeQuery(query);

stmnt.executeUpdate("SET PASSWORD=PASSWORD('Test')");

Error:

(Remark: Invalid SQL statement)

java.sql.SQLException: [Microsoft][ODBC Excel Driver] 柍澚揑 SQL 捖弎幃丟梐婜堊'DELETE'丄'INSERT'丄'PROCEDURE'丄'SELECT' 埥 'UPDATE' 丅

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)

at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)

at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3111)

at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)

at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)

at hk.gov.edb.util.ExcelHandle.updateNewEmail(ExcelHandle.java:414)

at hk.gov.edb.core.AppMain.doUpdate(AppMain.java:369)

at hk.gov.edb.core.AppMain$7.construct(AppMain.java:584)

at hk.gov.edb.util.SwingWorker$2.run(SwingWorker.java:127)

at java.lang.Thread.run(Thread.java:595)

kzyoa at 2007-7-13 0:16:58 >

Indeed, the SET command must be unsupported in OCDB Unfortunate.

I have on numerous occasions used a programme to extract everything from excel into a proper database where it can be fully manipulated rather than bother stuggling with Excel 'spreadsheets pretending to databases'.

My advice in most circumstances would be to scrap Excel as it is not designed for fast data retrieval by and programme besides Excel.

(If you don't mind my asking ) Why do you need to password protect the shpreadsheet? If your programme is running on the clientside, the user can open the spreadsheet without your programme. If your programme is running on the serverside, you can use your programme to not serve anything unless the user enters a password (use the programme to handle the password).

Bamkin

bamkin-ov-lestaa at 2007-7-13 0:16:58 >