Re: how to get excel into oracle

All,

Thanks for the quick responses. Okay so now that you have convinced me I need to use SQL Loader to get the data in, I can accept that. I'm guessing I can also create the script that will be used by SQL Loader to just append the data to the specified table etc.

How about my P.S. question? Is there client software already created where users can go into the db to modify data etc such as the table editor in schema manager? Some client front end that might work on both Windows and Unix platform? Or does this need to be developed in Java/Visual Basic?

Thanks in advance for your comments,

Jack

miaemp_at_my-deja.com wrote:

> If you export the Excel data in a delimited or fixed format, you could
> use SQL Loader to load the data into the table you want. Most of the
> effort would be in writing the script to perform the SQL Load and then
> exporting of the data.
>
> HTH
> Eric Peterson, DBA
> Maurices Inc.
> eric_NOpeterson_at_maurices.inrgSPAMMERS.com
>
Received on Tue Feb 22 2000 - 15:12:05 CST