Re: Simple Question Access and Oracle

You will also have to watch out for lower-case table names...these are a pain to work with in Oracle, so convert your Access table names to all caps before exporting(saving) it to Oracle...

"bigrez" <resnimi_at_NOSPAMmail.northgrum.com> wrote:

>I do it all the time. You'll need the ODBC connection set up on the PC.
>Then open the Access table and do a File/Save as... To an external database
>and follow the prompts.
> You'll need to account for Yes/No and memo fields as they don't directly
>map to the oracle data types.
>
>Mike
>==============
>Leena wrote in message
><642A954DD517D411B20C00508BCF23B00125488E_at_mail.sauder.com>...
>>Hi all,
>>
>>How easy is it to move Microsoft Access database information over to
 Oracle?
>>
>>Thanks in advance.
>>
>>Leena
>>
>>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Tue Jun 27 2000 - 00:00:00 CDT