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

Home -> Community -> Usenet -> c.d.o.server -> Re: MDB file

Re: MDB file

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 2 Feb 2001 09:07:41 -0000
Message-ID: <95dtd3$cqi$1@soap.pipex.net>

.mdb is indeed the jet file format. Your options are

  1. Link Tables in access and update from there
  2. export from access to flat file & use sql*loader

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...

> 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
Received on Fri Feb 02 2001 - 03:07:41 CST

Original text of this message

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