Re: Data Export

Mutliple ways to export data into files:

1. Using Reports: Do the data model and choose the output mode as character and run the report into a file out put. There will be spaces between columns or you can concatenate your text delimiters of choice. Then you can do whatever with the output file. We use this to generate excel spreadsheet outputs.
2. Discover 2000 also can do the data export. After you built your query you can save the output in many different ways (spreadsheets, text, etc.)
3. Forms 4.5 has TEXT_IO package which will do the data input into text files. We do this to upload our data into legacy systems (pre-defined formats, spacings).

HTH Prasad Chavali
pchavali_at_assettech.com
Andy Steffen wrote in message <35868925.65DC_at_hotmail.com>...
>Hi,
>
>Im working with Oracle 7 and Developer 2000 at NT 4.0 and I would like
>to know if there ist any easy way to export the data (only the contents)
>of a table or query into a file, so the colums are separated by tabstops
>or anything else.
>
>I need the data in a word document with mail merge. Sometimes I will
>have to distribute the data to other users and they dont have oracle.
>
>Thanks
>Andy
Received on Tue Jun 16 1998 - 22:40:02 CEST