Re: Data Migration from MS-EXCEL to Oracle

From: Rob Calfee <trace_at_primenet.com>
Date: Mon, 13 Sep 1999 14:02:59 GMT
Message-ID: <37dd0307.249568346@news.primenet.com>

There are more than a few ways to accomplish this.

Port the Excel file to a flat file and write a SQL Loader Script to improt the data to a pre-made table. FREE
Assuming that you have the Access migration assistant for Oracle 8, you can convert the excel file to Access and migrate the tables from Access to Oracle using the migration assistant. Your tables will be based on the format of the excel spreadsheet and will be made for you. FREE
Use a tool like Data Junction (www.datajunction.com -- free evaulation copy) to use your excel spreadsheet as the source and the oracle tables as the target to migrate the data into pre-made tables in Oracle. NOT FREE but the demo is!

Hope this helps and good luck.

Rob Calfee

On Mon, 13 Sep 1999 06:33:17 GMT, rgoyal_at_techbooks.com wrote:

>Hi!
>
>I would like to know if any Tools/Utility available
>for migration of data from MicroSoft EXCEL 97 to ORACLE 8.
>
>Thanks,
>
>Rajendra
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Rob Calfee
DBA
rcalfee_at_incsystem.com Received on Mon Sep 13 1999 - 09:02:59 CDT