Re: Excel to Oracle Export of data

From: Tom Best <tom.best_at_bentley.com>
Date: 2000/06/08
Message-ID: <8hoecu$rq$1@news.bentley.com>#1/1

Why would you go to Access if your goal is to get it into Oracle?

You can use Oracle ODBC Foreign Data Service, and, in Oracle, simply insert into oracletable select * from Excelspreadtable_at_odbclink.

C r a i g e r s <dotacion.nospam_at_st-helena.zzn.com> wrote in message news:8hmoec$o4d_at_gap.cco.caltech.edu...
> Want to begin regular export from spreadsheets, several times daily.
>
> I don't want manual intervention to create the necessary csv files.
>
> Has anyone got a way to suck the data out of a closed worksheets, or even
> better, without even opening excel, and create the csv?
>
> ODBC connection from Excel to Access isn't really an option.
>
>
> --
> C r a i g e r s
> Oracle Environment
> Oracle 7.3.4; 10.7 NCA
> Solaris
> Designer: Reports 2.5, Forms 4.5
>
>
Received on Thu Jun 08 2000 - 00:00:00 CDT