aspose file tools*
The moose likes JDBC and the fly likes Extract data from Oracle and upload to Ms Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Extract data from Oracle and upload to Ms Access" Watch "Extract data from Oracle and upload to Ms Access" New topic
Author

Extract data from Oracle and upload to Ms Access

Chhaya Dhanani
Ranch Hand

Joined: Apr 11, 2001
Posts: 70
Dear all,
I have a query which goes lije this:
Can i upload the resultset to MS Access which is recd from passing a select query to orcale.
Will do Connection objects be reqd for this.
Can this be achieved without jdbc or any programming involvement i.e. directly from Oracle to access using Reports in Oracle?
Thanks
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
You can definitely do it using two Connection objects.


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Extract data from Oracle and upload to Ms Access