Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What software do I need to migrate a Microsoft Access 97 database to an Oracle database?

April 26, 2017database Microsoft migrate oracle database Software

0

Posted

What software do I need to migrate a Microsoft Access 97 database to an Oracle database?

1 Answer

0

Posted

In order to migrate a Microsoft Access 97 database to an Oracle database, you must have the following software installed on the same system as the Migration Workbench: An ODBC driver release 4.00.4202.00 or greater. You can obtain this by downloading the latest version of the Microsoft Data Access Components (MDAC) from the Microsoft Web site at: http://www.microsoft.com Microsoft Data Access Objects (DAO) release 3.5. You can obtain this by downloading Microsoft Access 97. Microsoft Access 97. An Oracle ODBC driver. This allow Microsoft Access forms and reports to work with the migrated data. To install the Oracle ODBC driver, select the Custom Install option when installing the Migration Workbench. After you have installed the Oracle ODBC driver, you should set the Oracle ODBC Data Source. See Also: For more information, see Setting the Oracle ODBC Data Source in the Oracle Migration Workbench Online Help.