Re: Microsoft Access to Oracle?

From: Noah Monsey <noah_at_indirect.com>
Date: 1995/11/24
Message-ID: <30b59a19.4536750_at_165.247.1.4>#1/1

kramer_at_HERCULES.CS.UREGINA.CA (david kramer) wrote:

>Hello Oracle Gurus!
>
>Are there any tools, wizards, programs, etc. of getting the
>Microsoft Access 2.0 Tables and databases into Oracle? The
>company I work for has lots of data in Access and would like
>to easily port over to Oracle. We know about the 'flat file'
>approach but if there is a commercial product available that
>could automate the process, please reply.
>
>Thanking you all in advance...
>Dave Kramer
>SaskPower
>Regina, Saskatchewan, Canada
>
>kramer_at_cs.uregina.ca
>
>
 The best way that I have found for moving data into  a Oracle database from MS Access, uses the  following steps:

        Manually create the table using sqlplus.

	Attach the table into MS Access using an
	ODBC connection Oracle. (The Oracle rdbms
	can be other local or connected via SQL*Net.)

	Create a MS Access query that does an append
	to the attached table.

 By creating the tables first in the Oracle rdbms, you can
 build in integrity constraints. 	(not null, primary key, foreign

 key, etc . . .).

 Using MS Access to "export" the table to an Oracle database  has not worked for me. MS Access does not handle mapping  of the data types very well.
========= ========= ========= ========= =========

Noah Monsey                       noah_at_indirect.com

========= ========= ========= ========= ========= The only dumb question is the one that you don't ask. ========= ========= ========= ========= ========= Oracle Master Database Administration, April 1992 Oracle Master Application Development, April 1992 ========= ========= ========= ========= ========= Received on Fri Nov 24 1995 - 00:00:00 CET