Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Excel to Oracle Export of data
<holmesb_at_my-deja.com> wrote in message news:8hogfo$4qd$1_at_nnrp1.deja.com...
: "C r a i g e r s"
: > 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.
: >
: How about Perl and Perl DBI?
have not used Perl before. does it have the capability of reading a closed .xls file and extracting the values? or, ?
-- C r a i g e r sReceived on Thu Jun 08 2000 - 00:00:00 CDT