Re: how to get excel into oracle

Use ODBC Excel driver (Microsoft, Intersolv,..)

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

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?

>

>