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_at_paris.btinternet.com>
Date: Wed, 27 Feb 2002 19:43:27 +0000 (UTC)
Message-ID: <a5jcst$hh3$1_at_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 - 20:43:27 CET