Re: Access-to-Oracle

Download from
http://otn.oracle.com/software/tech/migration/workbench/content.html the migration workbench plus the add on from acces first you must convert the access database to xml with the tool supplied.

On Mon, 07 Jan 2002 21:08:46 GMT, Bricklen Anderson <bricklen_at_shaw.ca> wrote:

>you can download the migration workbench from
>http://otn.oracle.com/software/tech/migration/workbench/content.html
>or just go the download page at oracle's site, choose the right-hand
>drop-down list and search through that one (the utilities and drivers
>one).
>Dan Barron wrote:
>>
>> A common question I'm sure, but here goes...
>>
>> I'm an experienced DBA who is using Oracle for the first time. I have
>> a couple of Access databases to convert and was wondering what you all
>> think is the best way to accomplish this. The databases are Access
>> 2000 databases and my Oracle 8i version is 8.1.7.0.0.
>>
>> I read about a Migration Assistant, but it seemed limited Access 97
>> plus I couldn't find it anywhere to download. Is the MA the best way?
>> I could write an SQL script to create the tables, etc. and then export
>> the data to text files and import, but that seems like a lot of work.
>> I've tried the "Export" command in Access, but the results are not
>> satisfactory (it seems very stupid about data types, for one thing.)
>>
>> Any help or pointers to information as to the best way to accomplish
>> this would be much appreciated.
>>
>> dan
>>
>> Dan Barron
>> ACP-ASIM
>> dbarron_at_mail.acponline.org
Received on Fri Jan 11 2002 - 17:40:56 CST