Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MDB file
.mdb is indeed the jet file format. Your options are
Under Oracle 8i you would also have the option of the Oracle Migration Assistant.
-- Niall Litchfield Oracle DBA Audit Commission UK "Audun Jensen" <audun_j_at_yahoo.no> wrote in message news:Xns903C586B4F571audun.jyahoo.no_at_130.133.1.4...Received on Fri Feb 02 2001 - 03:07:41 CST
> ether_nut_at_my-deja.com wrote in <95c7ge$e8$1_at_nnrp1.deja.com>:
>
> >
> >
> >how do you import an mdb file or delimited .txt into Oracle 7.3.4 under
> >user "test"?
> >
> >thanks
> >
> >
> >Sent via Deja.com
> >http://www.deja.com/
>
> I guess this is an Access database file. In Access, you could link up your
> Oracle database (external linked tables) and just run an Insert
>
> create ora_table as select * from access_table
>
> AJ