Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Loading Excel sheets into Oracle
Just an Idea, but a Macro in Excel should be able to do this... Check the docs for possible examples..
"Luciano Belotto" <luciano_at_nospam.com> wrote:
>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?
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue May 28 2002 - 11:14:19 CDT