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

"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:26:38 CDT