Re: Question : Importing table from MS Access

I think creating the same table in oracle as an oracle object is best...

then once it exists (empty) use access to cut all the records from the access table and paste into the oracle table.

(this means create some link tables to each table in access first then cut and paste)...

this way you dont get caught by those d**n lower case letters and potentially whacky access ideas on primary keys and relationships...

randy

Richard Armstrong wrote:

> Yes. Via an ODBC connection, and an Oracle user id that has create table
> privileges. You do this through MS Access. Be very careful to create the
> table in uppercase letters, or you will have a heck of a time referencing
> it. You might want to check with your local DBA as to policy related to
> this action before you do it.
>
> --
> ****************************************
> Richard Armstrong
> State Of The Art Consulting, Inc.
> http://www.stateoart.com
> ****************************************
> François Thibault <francoist_at_rsa.qc.ca> wrote in message
> news:928763582.371.41_at_news.remarQ.com...
> > Is it possible to take already existing tables in MS Access and to import
> it
> > in a Oracle Db???
> >
> >
Received on Fri Jun 11 1999 - 20:04:44 CDT