Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Migrating from Access to Oracle

RE: Migrating from Access to Oracle

From: Mark Leith <>
Date: Fri, 02 Feb 2001 05:14:26 -0800
Message-ID: <>

Hi Beatriz

We work with our sales tracking system on Access (2000), and have test systems on Oracle, with most of the sales data imported to test against. SQL*Loader can be quite handy to do this, and once you get the hang of it
(creating the control files for example) it can be quite easy. If you will
be updating Oracle down this path from Access, you can just save the control file away, and not really have to worry about it again. You then just input the path to your controlfile, take you new export every time, and shabang you've got a table full of data..

There are also other options to consider as well. For example, you can link tables from Oracle to access as well. This then means you can still use the Access forms (which can be pretty good), but actually pull the data in from the Oracle tables. You can also create Macros to append all new data from Access to Oracle at any given time..

You will no doubt hear a lot " OH GOD NOT ACCESS!?!?!" from this list at this time as there is a holy war flying around against all Micro$oft products, but in reality, once these routines are set up they run quite well, with near to no interevention required.

There are a few things to bear in mind, like matching data types, as Access has some funny ones out there like MEMO, timestamps. But you can read more about this in the following PDF:

All in all, it seems to work well. If you have any specific questions whilst running through this, point them in my direction, and I'll see if I can help you out.

HTH Mark

"To infinity - and BEYOND"

Buzz Lightyear

-----Original Message-----
Martínez Jiménez
Sent: Friday, February 02, 2001 11:26
To: Multiple recipients of list ORACLE-L

I know that recently there has been some questions about this migration, despite of this, it´s not enough clear for me. Actually my company works with Access 97 (I know it´s a little prehistoric), and the data volume increases and increases. So, we are considerind adopting Oracle. I really would like to get into this amusing community. But I need to know details about the efectiveness of this change.
I have read something about the SQL*loader utility. It seems to be hard, does it really work? Does it give problems? But what really scares me isn´t the change itself, but working simultaneously with them, and what it implies.

I suppose any of you have done it previously. Should I follow some direction having in mind this change? Could you give some advice or share some experiences with me about this?

Beatriz Martínez Jiménez
 Ingeniera Informática
Fundación CIDAUT
 Parque Tecnológico de Boecillo, parcela 209
 Boecillo 47151
 tfno.983 54 80 35

Please see the official ORACLE-L FAQ:
Author: Mark Leith

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Feb 02 2001 - 07:14:26 CST

Original text of this message