Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Extract data from Oracle and upload to Ms Access

 
Chhaya Dhanani
Ranch Hand
Posts: 70
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can definitely do it using two Connection objects.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic