Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Automatic import of a text file into an Oracle database

Automatic import of a text file into an Oracle database

From: Lars Mollerup <lars.mollerup_at_niva.no>
Date: Tue, 17 Jun 2003 15:13:49 +0200
Message-ID: <bcn45r$8di$1@dolly.uninett.no>


Hello folks!

here is my question:

What is the best way to get data from a character delimited text file into an oracle database once a day. It should import it automatically and check the data before inserting values into tables?

(I am thinking of making a VB program to do this but could it be be done by scheduling a
stored procedure or some other Oracle specific way?)

TIA Lars Mollerup
NIVA, Norway Received on Tue Jun 17 2003 - 08:13:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US