Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question : Importing table from MS Access

Re: Question : Importing table from MS Access

From: Karen Morgan <KMMorgan_at_erols.com>
Date: Mon, 7 Jun 1999 21:08:44 -0500
Message-ID: <7jhql0$44p$1@autumn.news.rcn.net>


In addition, be sure to have all your fields in uppercase letters. And both the table name and the field names must not contain spaces.

Good Luck,

Karen Morgn
KCS Consulting

Richard Armstrong wrote in message
<7jh4dj$n93$1_at_bgtnsc01.worldnet.att.net>...
>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 Mon Jun 07 1999 - 21:08:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US