Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Import Excel file data into Oracle
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