connecting excel to an oracle DB

Question

how do i connect excel to an oracle DB?

Answer 1

Here's a good article on connecting Excel to Oracle:

http://www.databasejournal.com/features/oracle/article.php/10893%5F3358411%5F3/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm

Answer 2

If you want a very flexible 3rd party tool check out Apatar: http://www.apatar.com/

It allows you to take data from many (15+) types of sources, transform it how you wish, and then store it into a different type of source. It should be able to handle Excel to Oracle just fine.