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.

.

Relevant Pages

  • Re: Adding durations/phone bill
    ... Have been off-line for a while - looks like Ian has sorted it out. ... Basically, the data is text (in an Excel file), so it has to be ... High light a cell, click sigma, select range of cells, enter. ...
    (microsoft.public.excel)
  • More Help Needed..please
    ... By the way, if for some reason you ever select a cell in column A, the above ... I was going to use both Worksheet_Change & Workbook_Open in an Excel file ... "CNine" is in the same row as the ActiveCell, but always one column to the ...
    (microsoft.public.excel.programming)
  • Re: Activating a specific excel file
    ... The following macro accesses cells in an Excel file. ... Dim fileName As String ... By clicking a userdefined paste button de value of a second cell in the ...
    (microsoft.public.word.vba.general)
  • Re: Activating a specific excel file
    ... The following macro accesses cells in an Excel file. ... Dim fileName As String ... By clicking a userdefined paste button de value of a second cell in the ...
    (microsoft.public.word.vba.general)
  • Re: Find in Oracle
    ... I manage to extract the data from Oracle and saved them into Excel but I ... need to limit the output using a worksheet within the excel file. ... Dim Database_Name As String ...
    (microsoft.public.excel.programming)