Re: Retrieving data from an Oracle Database

From: Stephen Reynolds <null_at_bitbucket.com>
Date: Wed, 9 Jun 1999 20:01:01 +0930
Message-ID: <375e42e9.0@news.camtech.net.au>

You can extract the data with a SQL query, concatenating the columns with a delimiter - often a comma. Spool the output to a text file, any extension you like, but usually .txt

Remove any surplus strings from the top and bottom of the file, so that you have "clean" data, before importing it into Access.

Steve

Nic <nic.smith_at_bib-group.co.uk> wrote in message news:375E3A3F.D95DD544_at_bib-group.co.uk...
> The data for an Oracle Database - what would be the filename for the
> data ie what would be the file extension?
>
> How would I retrieve this data and export it to another database
> style such as MS Access?
> --
> Merry Ye Meet, And Merry Ye Part, To Merry Meet Again!
>
> Nic
Received on Wed Jun 09 1999 - 05:31:01 CDT