Re: Importing Data!

From: Jorge Meirim <transparente_at_mail.telepac.pt>
Date: Wed, 27 Jan 1999 00:25:41 -0000
Message-ID: <78okqq$hda@brown.telepac.pt>

Hi,

I'm almost sure it will work:

Configure you access/dbf/fox as odbc source. Then when connected to an oracle session using sqlplus on a PC:

copy from user/@odbc:your_odbc_name -
create -
using -
select * from your_table;

You can always create first your table in sql*plus and issue append/insert instead of create in copy command.

nice hu?

J. Meirim

Daniel Cukier escreveu na mensagem <785cfo$ro$1_at_news.mandic.com.br>...
>Hi,
>I'd like to know what is the best way to import Data from an Access MDB
file
>or a FoxPro DBF file to a Oracle Database.
>Is there any program witch does it automatically?
>
>Thanks
>
>Daniel Cukier
>
>
Received on Tue Jan 26 1999 - 18:25:41 CST