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

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 Received on Tue Jul 11 2006 - 09:00:45 CDT