Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unanswered: exporting oracle tables from unix to windows microsoft access

    i have a unix server running oracle database and need to export a table and import it to access on a windows machine. any idea of what i should do?

  2. #2
    Join Date
    Oct 2004
    Oklahoma City OK -

    -- log in to sql plus
    -- set some parameters
    set serveroutput on;
    set head off;
    set pagesize 10000;
    set linesize 10000;
    set arraysize 1;
    --open a spool file
    spool path/file.txt;
    -- execute a select statement with each element of the table delimited by the pipe symbol
    -- OR USE TOAD 
    spool off;
    --launch access, FILE, GET EXTERNAL DATA, IMPORT

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Create an ODBC link on the machine running access that points to the oracle machine. Then you can do one of two things.

    1) Create an external ODBC link in the files tab and simply use the oracle table directly.
    2) Import the table by using new/import under the file tab.

    The nice thing about import is that it keeps the column names, types, and sizes
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts