Re: Oracle import from Access

Max Berle <no-spam.max.mberle_at_pironet.de> wrote:

>Majeed wrote:
>>
>> Hi
>>
>> Is it possible to import an access .mdb into oracle
>>
>> Thankz
>
>hi majeed,
>
>sure it is. just have an access append-query insert the data into your
>linked oracle table. remember to have a primary key !
>
>--
>cu maxx
>
>to reply just remove the no-spam. from my address

One other caveat that I ran into...be sure that the Table Name is in all caps before the save as export... is done.... Lower case table names in Oracle are more difficult to work with and not worth the extra effort...

John Greco
Oracle DBA Received on Tue May 19 1998 - 09:46:55 CDT