Re: [Oracle / Access]

[Quoted] If the Access table has the following characteristics, you can simply export the table from Access to Oracle over an ODBC connection:

1. Table Name conforms to Oracle naming conventions (i.e., upper case, no special chars, etc)
2. All fields names conform to Oracle naming conventions (see 1.)
3. All fields types are compatible with Oracle field types (no "memo" fields, no "double" fields, etc)
4. The table must have a primary key (no strictly true, but simplifies things)

Note: if you export the Access table to Oracle (successfully) and later discover that you forgot to uppercase all names, you can fix this by referring to the name in double quotes:

select "my_lowercase_field_name" from "my_lowercase_table_name" where...

As an aside, I have found that for regular moving of large volumes of (the same tables') data from Access to Oracle is more quickly accomplished using an Access exported (fixed-width) file, then using SQL*Loader up into Oracle. (Access via ODBC is ungodly slow)

"Kelly Wilcox" <tcwilck_at_tc.cc.va.us> wrote in message news:veM45.23895$ds.697772_at_newsread2.prod.itd.earthlink.net...
> This may not be the best approach, but here's what I do:
>
> 1. Open up your Access DB
> 2. Create tables on Oracle to mirror the tables in Access
> 3. Create Insert Queries in Access to copy the data
>
> Anyone else? I have to do this every now and again myself - is anybody
 else
> using a different method?
>
> hth,
> Kelly Wilcox
>
> EECKEMAN Jérémie wrote in message ...
> >I would like to import a microsoft access database to Oracle Server...
> >
> >Does anyone can send me documentation or tips ?
> >
> >Thanks !
> >
> >
> >-----------------------------
> >Jérémie Eeckeman
> >Systems Developper
> >
> >Framfab
> >76, avenue Pierre Brossolette
> >92440 Malakoff
> >
> >tel : 01-55-48-11-00
> >fax : 01-47-35-00-00
> >http://www.framfab.fr
> >mailto : jeeckeman_at_framfab.fr
> >
> >
> >
>
>
Received on Wed Jun 28 2000 - 00:00:00 CEST