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: Migrating from MS Access to Oracle 8i

Re: Migrating from MS Access to Oracle 8i

From: Safeer <safeer_at_nettaxi.com>
Date: Fri, 26 Oct 2001 11:54:47 -0400
Message-ID: <9rc104$sd78t$1@ID-100405.news.dfncis.de>


Create and odbc ConnectString for Oracle and in MS Acess, File->SaveAs select odbc from the selection and there you go.

Muhammad Safeer.

"FaheemRao" <faheemrao_at_yahoo.com> wrote in message news:43b58913.0110241727.71041437_at_posting.google.com...
> Ok, Very easy Solution
>
> use Oracle Migration Work bench.
>
> It is a GUI based tool and can Convert the Data from MS Access to Oracle.
> It comes with Oracle Server.
>
>
> Faheem Rao
>
>
> "trub3101" <michael_at_bassline01.fsnet.co.uk> wrote in message
news:<9r6vos$1t$1_at_news7.svr.pol.co.uk>...
> > Hi
> >
> > Please bear with me on this as I am a relative newcomer with databases
(two
> > months) !
> >
> > I am currently engaged in a project at work whereby I am suppose to
transfer
> > data from an MS Access (no SQL Server) to the Oracle 8i database
> > environment.
> >
> > The problem is I am not quite sure where to start i.e. what are the
> > procedures involved and which are the best tools to use.
> >
> > I would be most grateful if someone could offer some assistance or point
me
> > in the right direction I should be looking to resolve this!
> >
> > Ta!
Received on Fri Oct 26 2001 - 10:54:47 CDT

Original text of this message

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