This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
Consider Paul's rocket mass heater.
 
subject: Extract data from Oracle and upload to Ms Access
 
Similar Threads
How to run multiple query in MS Access?
SQL doubt
regarding MS access sql query
abnormal window closing!!!
can Ms Access store Unicode ?