transporting excel

hello there,

I just installed 10g on my laptop n i want to transport an excel table to oracle database but i couldn't get through. can somebody help me out.


Thank you.



Wole.

Save spreadsheet as csv -- use SQL*Loader utility to load into Oracle table. ;)

Hello,

The latest version of DreamCoder includes some good options to upload data, I imported 5 Excel workbooks with 200.000 records apro. and just took 6 minutes.

Check this link : http://www.mentattech.com/themes/men...der/index.html

Regards,

Thank you all for your help, but am still having problem in loading from file since sql*loader has its own format, like bad file, controlfile etc. Can you pls help me on how to go about transporting it into my datatbase.

Thank you.