Hi, How can I Insert a value in one database table to another database table using JDBC. Please any one have the SQL query like that, and how can I write that program in Java. I am using MSAccess 2000. Thanks, Fyrose.
Hi, But I used this query like String query = " insert into UserInfo (UserName) in 'C:\\User.mdb' select UserInfo from RateInfo"; stmt.executeUpdate(query); Its inserting the UserName value of the UserInfo table into RateInfo table the value of UserInfo. But the problem is its inserting the next row. So the first row will be blank so how can I inser that in a first line. Could you solve this problem. Thanks, Sharief.
subject: Which SQL Statement should use for that??