Re: Import Tables

From: Dmitry <support_at_ispirer.com>
Date: Sat, 31 Mar 2001 05:06:10 -0700
Message-ID: <9a4h6p$3e5gq$1@ID-75577.news.dfncis.de>

Hi,

Oracle ships Migration Assistant for Access.

But if you choose to create a text file use CSV format instead of TAB. There are many examples of control files for this format in Oracle docs . If you are not experienced in SQL Loader it is difficult to create control file for TAB delimited file. There are no examples.

I recommend you to have a look at our tool Chyfo (http://www.ispirer.com/chyfo.html). It generates text files (CSV, TAB, fixed length), CREATE TABLE scripts and control files for SQL Loader.

Best regards, Dmitry.

"Corey Jackson" <jackson_at_oafa.pitt.edu> wrote in message news:3AC4CD50.1F8C0A02_at_oafa.pitt.edu...
> OK, I'm a newbie with Oracle, I'm using 8i, Personal Edition....
>
> Can I import tables from another format (Access, ODBC) without creating
> the table first in Oracle, exporting it to a tab-delimited format, and
> then importing it like that. MS Access would create the table, import
> the data in 1 step. Can Oracle 8i do it or is their an utility that
> will do it for me?
>
> Thanks,
> Corey
>
>
Received on Sat Mar 31 2001 - 06:06:10 CST