Re: uploading the contents of a spreadsheet

From: Chet Justice <chet.justice_at_pfsf.org>
Date: 26 Apr 2005 07:48:42 -0700
Message-ID: <1114526922.406193.251020@o13g2000cwo.googlegroups.com>

"Demetrius Sotiriades" <dsotiria..._at_wi.rr.com> wrote in
> Thanks,

> The project that I am working with is an ASP application using an
> Oracle database as one of its backends. Both IIS and the Oracle
> database are on servers outside my immediate network and of course
> there is no documentation. I can probably ask to have the
appropriate
> tools loaded on either machine. The first thing that I need to do is

> to really inspect the database so that I have some idea what I am
> working with and the second is to upload the information from the
> spreadsheet. From a quick glance it looks like HTMLDB would allow
me
> to do both And over the Web which would be great.

> If I cann't use HTMLDB what tool would you recommend for these
> purposes?

Why not just use external tables (if 9i and up)?

CDJUSTICE_at_PROD>CREATE DIRECTORY test_dir AS 'C:\TEMP';

Directory created.

Elapsed: 00:00:00.06
CDJUSTICE_at_PROD>CREATE TABLE ext_excel_file   2 (
  3 id NUMBER,
  4 x VARCHAR2(20),
  5 y NUMBER(5,2),
  6 z NUMBER(6,2)
  7 )
  8 ORGANIZATION EXTERNAL
  9 (

 10      TYPE ORACLE_LOADER
 11      DEFAULT DIRECTORY test_dir
 12      ACCESS PARAMETERS
 13      (
 14        RECORDS DELIMITED BY NEWLINE
 15        FIELDS TERMINATED BY ','
 16        OPTIONALLY ENCLOSED BY '"'
 17        MISSING FIELD VALUES ARE NULL
 18      )
 19      LOCATION ('myexcel.xls')

20 )
21 REJECT LIMIT UNLIMITED; Table created.

You could then transform it and load however you like.

chet Received on Tue Apr 26 2005 - 09:48:42 CDT