Re: MSaccess import???

From: Jinsong Qui <Jinsong_Qui_at_FirstDataBank.Com>
Date: 1997/08/15
Message-ID: <01bca990$5442f3f0$4371df26@jinsong>#1/1

Yes,

It works fine by creating tables in Oracle, linking the tabes from Access and loading data into the tables, then dis-link. But any one has solution for export tables directly into Oracle ?

I 'save as/export' two tables in Access into Oracle (7.3 work group). With the same user account, I can see the table name in user_tables view. But I can not locate the table by select, or drop. Error : table or view do not exist. Any way I can drop these two tables ?

Thank you.

Jinsong Qiu
jinsong_qui_at_firstdatabank.com

---

Matthias Gresz <GreMa_at_t-online.de> wrote in article <5suvpq$ts9$3_at_news01.btx.dtag.de>...
> Ed Lufker wrote:
> >
> > Hi all:
> >
> > Does anyone know how to move a MS-access table over to
> > oracle running on unix.??? I am using oracle 7.3.2.2.0
> >
> > thanks in advance
> > eddie lufker
>
> Hi,
>
>
> we had to import a 55 MB Access-databse into ORACLE. We created all
> tables in ORACLE. Then we linked the Tabels into the Access-db using
> ODBC and appended the records via Access-SQL. This took about 2 hours.
> Some error correction included.
>
> --
> Regards
>
> M.Gresz :-)
>
Received on Fri Aug 15 1997 - 00:00:00 CDT