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.