I've got a new tip I found on the net that I just had to share with everyone. It's a quick and easy way to get data from a spreadsheet into Oracle without the hassle of writing code.
Save the coded solutions, and there are many good ones, for the larger or repeating jobs. For those smaller or one-off jobs, this is the way to go. (My thanks go out to whomever first thought of this method, where ever you are.)
So basically, all we are going to do is use the spreadsheet to create a series of insert statements for us, then copy and paste those into our sql tool of choice.