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

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. Received on Tue Jul 11 2006 - 08:45:05 CDT