Re: how to get excel into oracle

Save the excel file as a comma delimited text file (though save as myfile.dat). then use the SQLLoader program to import it. You will need to create a control file (myfile.ctl) that tells Oracle what format the data is in, but my favorite way is to create the control and data in the same file, follow the parameters with BEGINDATA and after the {CR} place the first line of data, etc... just cut and paste it in there. This way when you call SQLLoader from the DOS prompt (or UNIX or whatever, syntax is the same) you only have to specify one file. Just fewer keystrokes, and fewer files to keep track of. BE SURE to specify a logfile and a bad file - this will be invaluable in telling you what didn't get inserted (myfile.bad) and why (myfile.log).

SQLServer 7.0 doesn't _suck_ (*ducks the rotten tomatoes coming her way*) - as a DBA for both Oracle and SQLServer, I can say that in truth. However - when dealing with non-microsoft data sources, it sure can be a pain in the butt. JMHO.

sonya

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:30:54 CST