Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORACLE EXPORT TO EXCEL, DBASE???
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