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

Home -> Community -> Usenet -> c.d.o.tools -> Re: How to populate data from text or MS ACCESS file to ORACLE database?

Re: How to populate data from text or MS ACCESS file to ORACLE database?

From: bhogak <bhogak_at_yahoo.com>
Date: Thu, 14 Jun 2001 19:46:49 -0500
Message-ID: <9gblsn$eoa$1@bob.news.rcn.net>

Depends on where your text/Access file is. If there are on the same Server where your Oracle Database is, then you can use UTL_FILE, else you might have to use TEXT_IO built-in in Forms.
bhogak
Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message news:3B2855B2.6DB1DDD3_at_exesolutions.com...
> Jingkai Yu wrote:
>
> > I need to populate data from text and MS ACCESS file to ORACLE database
> > from within Oracle Developer 2000, is there anybody knowing how to do
> > this?
> > If so, could you please show me how to do it? Thank you very much for
> > your time. You can post message on this board or send it to my mailbox.
> > Thanks again.
>
> Use the Oracle built-in package UTL_FILE and call if from a trigger on
 your
> form.
>
> Daniel A. Morgan
>
Received on Thu Jun 14 2001 - 19:46:49 CDT

Original text of this message

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