how to get excel into oracle

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 - 13:47:05 CST