Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Best way to store Excel spreadsheets in Oracle?

Re: Best way to store Excel spreadsheets in Oracle?

From: Michael Carton <MikeC_at_erols.com>
Date: Sun, 14 Jan 2001 19:38:21 -0500
Message-ID: <3A62467D.1C3B8822@erols.com>

Van Messner wrote:
>
> What do you all suggest as the most effective way to do this? Store a
> pointer to the document? Store the document? As what - a blob? And how is
> the document reconstituted with all of its formatting intact after you get
> in out of the database? They want to have users hit the database over the
> web and be able to see the spreadsheets they have permissions on.

I do this in my current application (Phase 1 in production has this feature, Phase 2 is in development.) I store the whole file in a LONG RAW column. Works out quite well.

-- 
MikeC

Please reply to the group.
Received on Sun Jan 14 2001 - 18:38:21 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US