Re: how to get excel into oracle

If you export the Excel data in a delimited or fixed format, you could use SQL Loader to load the data into the table you want. Most of the effort would be in writing the script to perform the SQL Load and then exporting of the data.

HTH
Eric Peterson, DBA
Maurices Inc.
eric_NOpeterson_at_maurices.inrgSPAMMERS.com

The views I have expressed here are solely my own and not that of my employer. To email me, respond to the email address provided, removing the NO and the SPAMMERS from the email address.

In article <38B2E7B9.85A31A75_at_lucent.com>,   Jack Montealegre <jmontealegre_at_lucent.com> wrote:
> Hey folks,
>
> Need help here. Beginner at 8i on NT and recently created some tables
> and views for a db to web application. I imported the data via
Oracle's
> Workbench beta program, thank god that program was out there. Now I'm
> having a problem with an input web form that is normally used by the
> clients. So now I've had to resort to getting in client's information
> some other way until I have time to work on the form.
>
> They have the table data in a Excel File. How do I get that data from
> the Excel file to the table in 8i with minimal amount of effort?
>
> I'm guessing you could save the excel file into a text tab delimited
> file and then somehow bring it into Oracle.
>
> But how? Boy some say MS SQL sucks but if I was using it, no brain
> energy would need to be spent for this move :) j/k
>
> Please help,
>
> Jack
>
> P.S. other than SQL Plus and my Web Forms is there client side
software
> that a user might use to input data? Maybe something that comes with
> Oracle which can use Net8 for connection?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 14:32:15 CST