Re: how to get excel into oracle

Another way of moving data into ORACL is. Create lots of insert Statements, this can be done easily in EXCEL, BUT this is a very slow method, if you have indexs on the tables. How ever the best way is using SQLloader, if data is in text format.

Tom

Jack Montealegre <jmontealegre_at_lucent.com> wrote in message news:38B2E7B9.85A31A75_at_lucent.com...
> 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?
>
>
Received on Tue Feb 22 2000 - 22:36:29 CST