Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!sn-xit-03!sn-xit-01!sn-post-02!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <gooiditweg@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: Need help with Oracle Loader??
Date: Tue, 12 Nov 2002 00:10:18 +0100
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <l2e0tu4c22872tr38q1hols955q68eh3al@4ax.com>
Reply-To: postbus@sybrandb.demon.nl
References: <a7bbb82.0211052034.59734833@posting.google.com> <3DD01519.9020802@t-online.de>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 20
Xref: newsfeed1.easynews.com comp.databases.oracle.server:166590
X-Received-Date: Mon, 11 Nov 2002 16:10:59 MST (news.easynews.com)

On Mon, 11 Nov 2002 21:37:45 +0100, Andreas Rainer
<andreas.rainer@t-online.de> wrote:

>Hello Romeo,
>
>use Export over ODBC, it is easy and you must not create a import-Script.


Just to be a little more clear about this
- set up an ODBC connection, using the ODBC administrator to Oracle
- fire up Access
- Choose Export, Choose ODBC, choose your ODBC connection, and export
the affected table(s)

Using Loader would be equivalent to using a sledgehammer


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address
