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:
http://otn.oracle.com/doc/oracle8i_816/nt.816/z26073.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
Hi,
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
[EMAIL PROTECTED]
Ingeniera Informática
Fundación CIDAUT
Parque Tecnológico de Boecillo, parcela 209
Boecillo 47151
Valladolid
tfno.983 54 80 35
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
