Unanswered: Import Excel spreadsheet into oracle 9i
As subject reads ... I want to import an excel sheet into oracle 9i. I am aware that I need to save the spreadsheet as .CSV but reading around I have seen sql*loader being used to do the import. Am I right in thinking 9i doesnt support this and uses external tables instead ? If this is correct then do I need privilages to create a directory on the oracle server when using external tables?