Re: output to dbf

hi,
thanks for the suggestion. but i was looking for a more direct method. ie from any developer tool (possibly using some standard package/procedure), generate a dbf file directly (without intermediate text/cvf file)

bob sullivan wrote:

> Big Bear wrote:
> > can anyone tell me if its possible to generate a dbf (eg, foxpro/dbase)
> > file from developer (report, forms or pl/sql). if so could you pls let
> > me know how to do it.
>
> This is kind of a roundabout way of doing it, but I know it'll work,
> because I've had to do it before. :)
>
> If you're using PL/SQL, use your favorite method to get a quote-and-
> comma-delimited file (in SQL*Plus, set serveroutput on and do a
> dbms_output.put_line with the columns you want, concatenated together
> with quotes and commas between each column; spool the output). Import
> the text file into an MS Access table then save the table as a .DBF
> file. (You're supposed to be able to do it with Excel, also, but I've
> never been able to get a .DBF file with Excel that I could view with
> Clipper utilities, such as DBX or DBU.)
>
> hth,
> ~bob
Received on Tue May 09 2000 - 00:00:00 CEST