Re: Import Tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 30 Mar 2001 20:35:22 +0200
Message-ID: <tc9ma343fapca5@beta-news.demon.nl>

"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
>
>

You can export from Access to Oracle using ODBC (provided your column names are in upper case and don't use funny characters like spaces and minuses).
If you export to a tab delimited file, you need to use sqlloader and pre-create the table.
Oracle comes with documentation, please try to read it.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Mar 30 2001 - 12:35:22 CST