Re: Is it possible to load the excel file by using external table without converting it into csv comma delimited file

From: Khurram <oraware_at_gmail.com>
Date: 11 Jul 2006 07:34:11 -0700
Message-ID: <1152628451.651944.63410@35g2000cwc.googlegroups.com>

hi

Thanx Mark It seems to me sound idea i appreciate yours suggestion but dun mind i still try to find the solution from Oracle product :).

Thanx again Mark.

Khurram
Mark C. Stock wrote:
> "Khurram" <oraware_at_gmail.com> wrote in message
> news:1152626444.901100.140560_at_h48g2000cwc.googlegroups.com...
> :
> : Charles Hooper wrote:
> : > Khurram wrote:
> : > > hi
> : > >
> : > > I am using oracle 9.2.0.1.0 version..
> : > >
> : > > Is it possible to load the excel file by using external table without
> : > > converting it into csv comma delimited file??
> : > >
> : > > If yes then please tell me how can i achieve it
> : > >
> : > > I want to fileds terminated by cell for excel file.
> : > >
> : > >
> : > > FIELDS TERMINATED BY <CELL>
> : > >
> : > > Thanx in advance
> : > >
> : > > Khurram
> : >
> : > I guess that I am not understanding.
> : >
> : > Are you trying to bring data from the Oracle database into Excel? If
> : > so, create an ODBC connection on the computer for the Oracle database,
> : > then use Microsoft Query (Import External Data in Excel) to retrieve
> : > inforrmation from the database by using a SQL statement.
> : >
> : > Or, are you trying to insert data into the Oracle data using the
> : > information in Excel? If so, you can either create a maco to feed the
> : > information into Oracle, or use Microsoft Access to link to the Excel
> : > spreadsheet and append the contents of the spreadsheet to a table in
> : > Oracle. A macro in Excel could be used to output a text file that
> : > terminates each of the cell contents with <CELL>, if desired.
> : >
> : > Charles Hooper
> : > PC Support Specialist
> : > K&M Machine-Fabricating, Inc.
> :
> : Hi Charles
> :
> : Thanx a lot for yours effort , i want to access the excel spreadsheet
> : data from external tables that do not reside in the database, and can
> : be in any format for which an access driver is provided.The external
> : data can be queried directly and in parallel using SQL.
> :
> : But external table requires fields termination seprator which is not in
> : excel ,to achieve it one need to convert excel spreadsheet to CSV comma
> : delimited file (We have monthly excel format outsource file),i wana
> : make users to avoid converting excel spread sheet to CSV format
> : repeteadly every month.
> :
> : Khurram
> : (',' delimited column) format
> :

>

> how about setting up a windows script program or a simple VB/C# program or
> even a dumb batch file to automate the conversion.

>

> or google on 'automate excel csv conversion' for utilities (some free) that
> can help

>

> it would probably be a lot simplier and more reliable to automate the CSV
> conversion than to write an external table spec to read the non-converted
> file (if that's even possible)
>
> ++ mcs
Received on Tue Jul 11 2006 - 09:34:11 CDT