FAQ
is there any tool that imports directly form ms acces to oracle?
with out having to export ms acces files to flat text files and then
load them in to oracle but some sort of direct importation? cheers

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged. If the reader
of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.
If you have received this communication in error, please
re-send this communication to the sender and delete the
original message or any copy of it from your computer
system.
Please do not re-send by any reazon in any way or form any of the
informatino here contained.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: agc
INET: acad_at_accefyn.org.co

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: ListGuru_at_fatcity.com (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).

Search Discussions

  • Cale, Rick T (Richard) at Sep 6, 2001 at 7:06 pm
    Supposely Oracle Migration Workbench will do this. You can get it from OTN.
    See http://technet.oracle.com/software/tech/migration/workbench/content.html

    There is also a tool with sql server client DTS that does a great job of
    this.

    Rick

    -----Original Message-----
    Sent: Thursday, September 06, 2001 3:59 PM
    To: Multiple recipients of list ORACLE-L

    is there any tool that imports directly form ms acces to oracle?
    with out having to export ms acces files to flat text files and then
    load them in to oracle but some sort of direct importation? cheers

    The information contained in this communication is
    confidential, is intended only for the use of the recipient
    named above, and may be legally privileged. If the reader
    of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or
    copying of this communication is strictly prohibited.
    If you have received this communication in error, please
    re-send this communication to the sender and delete the
    original message or any copy of it from your computer
    system.
    Please do not re-send by any reazon in any way or form any of the
    informatino here contained.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: agc
    INET: acad_at_accefyn.org.co

    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: ListGuru_at_fatcity.com (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Cale, Rick T (Richard)
    INET: RICHARD.T.CALE_at_saic.com

    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: ListGuru_at_fatcity.com (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).
  • Regina Harter at Sep 6, 2001 at 10:59 pm
    If you can get an ODBC connection from MS Access to Oracle, Access itself
    will do it. I have only done it myself once, but I might be able to get
    together with someone and try to remember how it is done...
    At 11:58 AM 9/6/01 -0800, you wrote:
    is there any tool that imports directly form ms acces to oracle?
    with out having to export ms acces files to flat text files and then
    load them in to oracle but some sort of direct importation? cheers

    The information contained in this communication is
    confidential, is intended only for the use of the recipient
    named above, and may be legally privileged. If the reader
    of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or
    copying of this communication is strictly prohibited.
    If you have received this communication in error, please
    re-send this communication to the sender and delete the
    original message or any copy of it from your computer
    system.
    Please do not re-send by any reazon in any way or form any of the
    informatino here contained.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: agc
    INET: acad_at_accefyn.org.co

    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: ListGuru_at_fatcity.com (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Regina Harter
    INET: rharter_at_emc-inc.com

    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: ListGuru_at_fatcity.com (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).
  • Arul kumar at Sep 7, 2001 at 5:22 am
    Hi agc,

    I remember a GUI Wizard from Oracle Enterprise Manager ( of ver.8 !) which
    provides easy steps to move data frm MS-Access to Oracle.

    hope this may help u.

    cheers,
    Arul.

    agc wrote:
    is there any tool that imports directly form ms acces to oracle?
    with out having to export ms acces files to flat text files and then
    load them in to oracle but some sort of direct importation? cheers

    The information contained in this communication is
    confidential, is intended only for the use of the recipient
    named above, and may be legally privileged. If the reader
    of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or
    copying of this communication is strictly prohibited.
    If you have received this communication in error, please
    re-send this communication to the sender and delete the
    original message or any copy of it from your computer
    system.
    Please do not re-send by any reazon in any way or form any of the
    informatino here contained.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: agc
    INET: acad_at_accefyn.org.co

    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: ListGuru_at_fatcity.com (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).
    Disclaimer

    This message (including any attachments) contains
    confidential information intended for a specific
    individual and purpose, and is protected by law.
    If you are not the intended recipient, you should
    delete this message and are hereby notified that
    any disclosure, copying, or distribution of this
    message, or the taking of any action based on it,
    is strictly prohibited.

    Visit us at http://www.mahindrabt.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Arul kumar
    INET: rakumar_at_mahindrabt.com

    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: ListGuru_at_fatcity.com (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).
  • Schmoldt_at_fyiowa.com at Sep 10, 2001 at 5:42 pm
    Oracle's Migration Workbench will do what you need, if you're on Oracle
    Client 8.1.7 or newer.
    -----Original Message-----
    From: agc
    Sent: Thursday, September 06, 2001 2:59 PM
    To: Multiple recipients of list ORACLE-L
    Subject: ms acces


    is there any tool that imports directly form ms acces to oracle?
    with out having to export ms acces files to flat text files and then
    load them in to oracle but some sort of direct importation? cheers

    The information contained in this communication is
    confidential, is intended only for the use of the recipient
    named above, and may be legally privileged. If the reader
    of this message is not the intended recipient, you are
    hereby notified that any dissemination, distribution or
    copying of this communication is strictly prohibited.
    If you have received this communication in error, please
    re-send this communication to the sender and delete the
    original message or any copy of it from your computer
    system.
    Please do not re-send by any reazon in any way or form any of the
    informatino here contained.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: agc
    INET: acad_at_accefyn.org.co

    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: ListGuru_at_fatcity.com (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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: schmoldt_at_fyiowa.com

    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: ListGuru_at_fatcity.com (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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 6, '01 at 6:46p
activeSep 10, '01 at 5:42p
posts5
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase