From: "Niall Litchfield" <n-litchfield@audit-commission.gov.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: MDB file
Date: Fri, 2 Feb 2001 09:07:41 -0000
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom
Lines: 36
Message-ID: <95dtd3$cqi$1@soap.pipex.net>
References: <95c7ge$e8$1@nnrp1.deja.com> <Xns903C586B4F571audun.jyahoo.no@130.133.1.4>
NNTP-Posting-Host: host9.audit-commission.gov.uk
X-Trace: soap.pipex.net 981104867 13138 193.128.236.219 (2 Feb 2001 09:07:47 GMT)
X-Complaints-To: abuse@uk.uu.net
NNTP-Posting-Date: 2 Feb 2001 09:07:47 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400


.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@yahoo.no> wrote in message
news:Xns903C586B4F571audun.jyahoo.no@130.133.1.4...
> ether_nut@my-deja.com wrote in <95c7ge$e8$1@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