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: ORACLE EXPORT TO EXCEL, DBASE???

Re: ORACLE EXPORT TO EXCEL, DBASE???

From: Ed Stevens <spamdump_at_nospam.noway.nohow>
Date: Wed, 27 Nov 2002 20:16:53 GMT
Message-ID: <3de527d1.73776945@ausnews.austin.ibm.com>


On Wed, 27 Nov 2002 07:11:17 +0100, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On 27 Nov 2002 02:46:16 GMT, ralphnoble_at_aol.com (RALPHNOBLE) wrote:
>
>>Thanks ... the Oracle database is of property records ... there's seven tables
>>in the database ... we simply need the data exported into a format we can
>>import into Microsoft Access, FoxPro or Excel. We're talking about 12K records
>>per table. I know in SQL Server it's a simple DTS export to the ODBC
>>application of my choosing. Is it that more difficult in Oracle just to get the
>>data in the tables exported to fixed-width or delimited flat text files, or
>>Excel, dBase or Access or something????
>>
>>Thanks,
>>
>>Ralph
>
>
>No, They could very easily make 7 separate sql statements to dump the
>tables in 7 csv files. Obviously, they don't know how to do it.
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address

Or they don't want to. We *are* talking about a gov't bureacracy here. And it's not been made clear what the relationship of the OP is to said agency.

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)
Received on Wed Nov 27 2002 - 14:16:53 CST

Original text of this message

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