Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with MS Access text export -> sqlldr -> Oracle

Re: Problems with MS Access text export -> sqlldr -> Oracle

From: Adrian Carlson-Hedges <adrian.ch_at_btinternet.com>
Date: Wed, 27 Feb 2002 19:43:27 +0000 (UTC)
Message-ID: <a5jcst$hh3$1@paris.btinternet.com>


I wish I didn't have to keep reading these adverts. If you really need to load data from Access to Oracle, there are many many ways of doing it. Not least of which is to simply make an ODBC connection to Oracle, and run an append query.

"Gerrit-Jan Linker" <gjlinker_at_oraxcel.com> wrote in message news:a5917l$q7f$1_at_paris.btinternet.com...
> What you could do is use SQL*XL to dump your information out into Excel.
> Then use Excel to save the file into the format you like. Excel is very
> flexible and allows you to export it to many different file types.
>
> Have a look at SQL*XL at http://www.oraxcel.com.
>
> Gerrit-Jan Linker
>
>
Received on Wed Feb 27 2002 - 13:43:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US