Is there a simple way to import Excel sheet or CSV file to Oracle DB?
Posted on 2011-02-27
please can somebody suggest some option how to import the data from Excel (simple table) or CSV file to the Oracle database?
I've got the data the way that somebody exported it for me from existing Oracle database, and I'd like to be able to import it to my database for dev/testing purposes.
It will be fine if this imports creates a new table. All values data types are just strings.