Re: Migrating from MS Access to Oracle 8i

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 - 12:14:59 CDT