Re: ORACLE EXPORT TO EXCEL, DBASE???

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 27 Nov 2002 07:11:17 +0100
Message-ID: <sdo8uukmbelnvnc2v3gtifdlhq4ee960gu@4ax.com>

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 Received on Wed Nov 27 2002 - 00:11:17 CST