<div>
- you can register and download for free Oracle's tool - sql developer from the following link and use its migration tool to migrate to sql server/access. :<br />
<br />
<a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html" rel="ugc">http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html</a>
</div>


- you can register and download for free Oracle's tool - sql developer from the following link and use its migration tool to migrate to sql server/access. :

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html [http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html]

<div>
- sorry i didnt see the earlier posting on sql developer.
</div>


- sorry i didnt see the earlier posting on sql developer.

<div>
- here a few links on steps to migrating the data from oracle to sql server:<br />
<a href="http://www.sql-server-performance.com/2003/migrating-from-oracle-to-sql-server/" rel="ugc">http://www.sql-server-performance.com/2003/migrating-from-oracle-to-sql-server/</a><br />
<a href="http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle" rel="ugc">http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle</a><br />
<a href="http://www.ehow.com/how_5982726_convert-oracle-sql-server.html" rel="ugc">http://www.ehow.com/how_5982726_convert-oracle-sql-server.html</a><br />
<br />

</div>


- here a few links on steps to migrating the data from oracle to sql server:
http://www.sql-server-performance.com/2003/migrating-from-oracle-to-sql-server/ [http://www.sql-server-performance.com/2003/migrating-from-oracle-to-sql-server/]
http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle [http://www.microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx#oracle]
http://www.ehow.com/how_5982726_convert-oracle-sql-server.html [http://www.ehow.com/how_5982726_convert-oracle-sql-server.html]



<div>
But, as long as I know, there's no way to migrate directly from a backup file.<br />
You need to restore it to a valid database and then migrate with any of the methods described.<br />
<br />
My prefered one is the Oracle Migration Workbench<br />
<a href="http://www.oracle.com/technetwork/database/migration/index-084442.html" rel="ugc">http://www.oracle.com/tech<wbr />network/da<wbr />tabase/mig<wbr />ration/ind<wbr />ex-084442.<wbr />html</a>
</div>


But, as long as I know, there's no way to migrate directly from a backup file.
You need to restore it to a valid database and then migrate with any of the methods described.

My prefered one is the Oracle Migration Workbench
http://www.oracle.com/technetwork/database/migration/index-084442.html [http://www.oracle.com/technetwork/database/migration/index-084442.html]

<div>
<div class="content wysiwyg-content">
Hi<br />
Can i import dat (from oracle) to MS access/SqL? and how?
</div>
</div>


Hi
Can i import dat (from oracle) to MS access/SqL? and how?

can i import dat (backup from oracle) to MS access/SqL? and how?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.