Re: porting Access DB to Oracle

From: Bo Lu <bo.lu_at_hsc.utah.edu>
Date: 1996/05/05
Message-ID: <4mina9$dsn_at_news.cc.utah.edu>#1/1

If you have installed SQL*Net for TCP/IP and Oracle ODBC on your PC, you can very easily use Access export function to export your tables and data to ORACLE database. But it seems that you do not have those stuff. If that is the case, you export you data in Access to a delimited ASCII file and then use Oracle's SQL*Loader utility to load the data into Oracle. Of course, you have to use FTP to copy your exported file from PC to HP.

-- 
Bo Lu
Programmer/Analyst
Hospital and Clinical Informatics, U. of Utah
Phone: 801-581-5964, E-Mail: bo.lu_at_hsc.med.utah.edu

Received on Sun May 05 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: ORACLE: "Oracle Announcements This Week, April 1, 1996"
Previous message: Loyal Barber: "Re: How to change date format in a PL/SQL block."
Maybe in reply to: Mirwais Qader: "Re: porting Access DB to Oracle"
Next in thread: ORACLE: "Oracle News"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message