Re: import from ACCESS

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Sun, 24 Sep 2000 13:08:49 -0700
Message-ID: <8qlmv3$l87$1@spiney.sierra.com>

Using an ODBC connection, you can EXPORT from MS-Access into Oracle. (this is full of problems revolving around "bad" table/field names, Memo/Long datatypes, etc.
but can be fixed.)

You can also export from MS-Access to a fixed width or tab delimited, then compose
an SQL*Loader script and import.

<seanldus_at_my-deja.com> wrote in message news:8qaquu$275$1_at_nnrp1.deja.com...
> What are the possible ways to get a bunch of access tables in to Oracle?
>
> Any help is appreciated.
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sun Sep 24 2000 - 15:08:49 CDT