For at least access there is the oracle migration utility which ships with
the product. This product also supports sybase and sql server. For generic
3rd party databases you will in general need to spec the tables and isert or
load the data. But then going from a flat file system to an rdbms is an
effort in itself.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"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 Fri Mar 30 2001 - 12:35:41 CST
