0

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?

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

1 Answer 1

0

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...)

H. Pauwelyn
9306 gold badges19 silver badges35 bronze badges
answered Oct 2, 2015 at 19:37

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.