File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Which type of query should be use?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which type of query should be use??" Watch "Which type of query should be use??" New topic
Author

Which type of query should be use??

Ahamed Sharif
Ranch Hand

Joined: Aug 24, 2003
Posts: 47
Hi,
Is it posible to insert single colume value from one DSN table to
another DSN table.
table: DSN1
Name Adrress City
aaa bbbb xxx
ccc sss yyy
table: DSN2
Phone Job City
eee ttt
qqq kkk
Finally the DSN2 table look like
table: DSN2
Phone Job City
eee ttt xxx
qqq kkk yyy
Any sql quely like inserting DSN1table City values into DSN2table
City.
I used this query but giving some problem
"insert into UserInfo (CITY) in 'C:\\User.mdb' select CITY from RateInfo";
its inserting the city value but remailning null, I mean not in a perticular row.
Help would be appriciated.
Thanks,
Ahamed.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which type of query should be use??