Re: how to get excel into oracle

If you've got ODBC connections etc. you can import the Excel ss into MS Access, then export the Access table(s) one by one to the Oracle instance. Easy. Just make sure (1) the Access table names and column names are all in upper case, to save the trouble of enclosing them in double quotes when they get to Oracle, and (2) you do not have a table with the same name in the Oracle schema receiving the export. This is my preferred method.
e.g. you could also save the Excel as delimited file (extension .csv) then use SQLLoader to import this to Oracle. Regards, Benits

Jack Montealegre 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?

-- 
Benita Haslett				email:	haslett_at_telusplanet.net
Oracle Analyst/DBA			Tel:	780-624-7072
Daishowa-Marubeni International Ltd.	Fax:	780-624-7086
Postal Bag 2200
Peace River, Alberta
T8S 1Y4