Is it possible to load a excel file with the headers into a temp table on Oracle?

I use TOAD for the interface.

I am needing to do some comparison on a a excel file with what we have in our database. Unfortunately, the data that is in the excel file is NOT in our database but in order for me to report on data, I need to bring it in for comparison.

Is this doable? If so, what would the appropriate approach be for this?

  • 1
    what tools do you have: SQL developer, Toad, PL/SQL developer?? they all have built in's to make it easier – kevinsky Oct 2 '15 at 19:35
  • Thank you Kevin, I use TOAD for Oracle. I ended up finding out how to accomplish the task. – Hector Oct 2 '15 at 19:37

First go to the menu and choose: database → create → table

The follow prompt, choose schema, select object type (view, table etc).

Also make sure your column structure does not interfere with importing since the same rules apply with importing data when it comes to column spaces etc.. (Column names with spaces etc...)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.