Re: Create Table from Excel-Data

1. Create a flat file of data in Excel, and save as CSV file type (comma-separated values).
2. Load with SQL*Load.
3. Finish the import through the Application menu.

There's a lot missing in the details there, I know. For instance, Oracle supplies standard Interface tables for Items, Bills of Material, Bill Components, Routers, Routing Operations and Routing Resources (Oracle Manufacturing), and I have loaded each of these, and finished the Import of each table through the Application. It works great.

I don't know a good way to load data otherwise, such as when Interface tables are not provided but you want to load tables directly. I am looking forward to trying a product called Oraxcel (take a look at http://members.aol.com/gjlinker/ ), which seems like it might work for us.

Chris

a922777 wrote:

> Can somebody tell me a quick way to create a table in Oracle based on
> data which is in Excel? Thanks. Erich Vontobel Switzerland
> --
> Posted via Talkway - http://www.talkway.com
> Surf Usenet at home, on the road, and by email -- always at Talkway.
Received on Fri Mar 19 1999 - 19:23:06 CET