Re: Loading Excel sheets into Oracle

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 28 May 2002 19:23:14 +0200
Message-ID: <ad0ehq$72v$1@crusher.de.colt.net>

"Luciano Belotto" <luciano_at_nospam.com> schrieb im Newsbeitrag news:ad0a2n$ha7_at_dispatch.concentric.net...
> I have an Excel file with multiple sheets. Each sheet has as it's first
row,
> the column or field header.
>
> Here's what I'd like to do:
> For each sheet in the file, automatically create an Oracle table (the
table
> name being the sheet name). Also automatically create all the fields in
the
> table, taking the first row as the field names for each column. The fields
> can all be strings (varchar2). Then populate the other rows as the data.
>
> I know I can do all this manually (saving each sheet as seperate file),
but
> I'd like it to be automatic and as easy as the push of the button with
just
> the Excel file itself. I'm hoping there's a program out there that does
> this?

I use OO4O and VBA for problems like this one.

Regards,

Knut Received on Tue May 28 2002 - 12:23:14 CDT