Re: Microsoft Excel Spreadsheet output, file format

From: tgraham <boardshorts_at_my-dejanews.com>
Date: Sat, 27 Feb 1999 14:36:05 GMT
Message-ID: <7b8vsk$e8b$1@nnrp1.dejanews.com>

We've got our unix box interfaced with a Netscape browser and we output text files files in a Comma Space, Quote Enclosed Delimited (CSV) format so the users download them and pull them into excel. The files are formatted with the SQL Eg.

SELECT long_record_seq, SUBSTR (LTRIM (TO_CHAR (T0.ACCOUNT_ID, '99999990')), 1,8) ||','|| '"' || SUBSTR (T2.ACCOUNT_CATEGORY, 1,2) ||'"' ||','|| '"' || SUBSTR .... etc

Once the files are written to the server in a CSV format the users can open them from the browser and use the "save as feature" Excel will walk the user through the steps to place the data in columns.

Hope this helps !

In article <7b2ppn$3mm$1_at_nnrp1.dejanews.com>, bonanos_at_yahoo.com wrote:
>
>
> > Install ODBC software on your PC, make a connection to the database, and use
> > excel's in built capabilities to query the database. That should be
> everything.
>
> I am looking for a way to pump out a spreadshet from a proc. as I want
> peope to be able to download the files through a browser.
> What I am looking for are the formating tags/codes
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 27 1999 - 08:36:05 CST