Re: Coverting/Exporting Ms Access databases to Oracle 9i?

From: Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com>
Date: Mon, 23 Feb 2004 15:27:57 GMT
Message-ID: <1_o_b.45124$Ff2.2324@clgrps12>

Ana C. Dent wrote:

> Edward Ascencio wrote:
>

>> Hi, Guys
>>
>>
>>
>>     How can I condense or convert access databases to oracle 9i?
>> I know you can import via comma delimited file, or text file but is 
>> there a
>> new method in converting access db to oracle?
>>
>> Any insight would be great ??

>
>
> How about using ODBC from Access to Oracle.
> Force object names to be all UPPER case in Oracle.
>

Or you could set up a heterogeneous service via odbc for the access db, create a dblink to the access db and do a "create table <oratable> as select * from <accesstable>@<dblink>" Received on Mon Feb 23 2004 - 09:27:57 CST