This discussion is archived
13 Replies Latest reply: Aug 28, 2013 1:56 PM by rp0428 RSS

Need to load large data set from Oracle table onto desktop using ODBC

hillelhalevi Newbie
Currently Being Moderated

I don't have TOAD nor any other tool for querying the database.  I'm wondering how I can load a large data set from an Oracle table onto my desktop using Excel or Access or some other tool using ODBC or not using ODBC if that's possible.  I need results to be in a .csv file or something similar. Speed is what is important here.  I'm looking to load more than 1 million but less than 10 million records at once.   Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points