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

    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
    Location
    Oklahoma City OK -
    Posts
    122

    Code:
    -- 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
    Location
    Liverpool, NY USA
    Posts
    2,509
    Easy,
    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
    Bill
    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
  •