SQL Server 2005 and connectivity to Oracle 10g

I am working on a new project where we would like to eliminate processes that
involve bulk loading data extracted from an Oracle 10g database into a SQL
Server 2005 database. The extracts come in the form of Excel worksheets.
Can I get the data from the Oracle DB directly, through linking or some other
method as opposed to loading the data from a work***? I'm completely new
to this, as our previous DBA\SQL developer left suddenly and I've been tasked
with this. Any help would be greatly appreciated.
.

Loading