Re: Import Excel file data into Oracle

From: CSC <jcheong_at_cooper.com.hk>
Date: 14 Jun 2003 15:02:45 GMT
Message-ID: <bcfdel$re2@imsp212.netvigator.com>

My Oracle version is 9.2. Actually, I need to transfer data from MSSQL Server to Oracle. The data source is from Excel file which is imported into MSSQL by application. Can I connect directly to MSSQL from Oracle? Can you explain a little bit on external tables, heterogeneous services and XML tree generation which are quite new to me?

Hans Forbrich <forbrich_at_telusplanet.net> wrote:
> There are many possible answers - external tables, heterogeneous
> services, SQL Loader, XML tree generation, and many more.

> Start by giving us a hint what version of the database you are looking
> at. Next, some specifics why you are doing this so we can guess at
> appropriate methods within your environment. A bit of sizing and OS
> related information might be useful to help narrow potential solutions.

> If you don't want to provide additional hints as requested above, then
> the simplest solution is: RTFM to review the possible universe of
> solutions.

> CSC wrote:

>> How can I import excel file into Oracle database? Received on Sat Jun 14 2003 - 10:02:45 CDT