Thanks TurkBear!
"TurkBear" <noone_at_nowhere.com> wrote in message
news:h26jttc75855hrobvr1b3e9dihd93j2his_at_4ax.com...
>
> Not quite that simple..
> First:
> Make sure all ACCESS tablenames conform to Oracle requirements ( see
Oracle docs) and make them UPPERCASE
> Make sure all data types are Oracle compatible and make the field names
UPPERCASE and Oracle compliant ( Docs again)
>
> [ Access allows datatypes and nomenclature that will give you problems in
Oracle; for example a Mixed case table name
> exported from Access will have a mixed-case name in Oracle - to use
SqlPlus with this table you will need to always enclose
> the name in dbl-quotes..same thing happens with mixed-case field names -
furthermore Oracle has rules about what can be in
> field names and table names - for instance no spaces are allowed in Table
or Field names ]
>
> So, once you make the data compatible,
> you can export to Oracle...
>
> The Migration Assistant handles these pretty well, but to do an export
(save as) from Access yourself, its up to you..
>
>
>
>
> "Safeer" <safeer_at_nettaxi.com> wrote:
>
> >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!
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Fri Oct 26 2001 - 15:02:50 CDT
