OraFAQ Forum: SQL & PL/SQL » Read excel file using UTL

Home » SQL & PL/SQL » SQL & PL/SQL » Read excel file using UTL_FILE package

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Read excel file using UTL_FILE package [message #467383]

Fri, 23 July 2010 13:10

rkhatiwala
Messages: 178
Registered: April 2007

Senior Member

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
"CORE 11.1.0.6.0 Production"

Hi,

Is there a way to read Excel file using UTL_FILE package ?
Like our usual method:
l_utlfile := utl_file.fopen(p_dir, p_filename, 'R',2000);

p_filename is event.xls

Or do we need to convert that file to .csv or .txt ?

Thanks.

Report message to a moderator

Re: Read excel file using UTL_FILE package [message #467385 is a reply to message #467383]

Fri, 23 July 2010 13:16

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Is there a way to read Excel file using UTL_FILE package ?

No, you need to convert the Excel file into a CSV one and then it is better to read it using SQL*Loader or external table.

Regards
Michel

Report message to a moderator

Re: Read excel file using UTL_FILE package [message #467387 is a reply to message #467385]

Fri, 23 July 2010 13:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there a way to read Excel file using UTL_FILE package ?
EXCEL can connect directly to Oracle RDBMS via ODBC & issue SQL directly against DB
All that is required is to load Oracle Client s/w onto PC running EXCEL.

Report message to a moderator

Re: Read excel file using UTL_FILE package [message #467404 is a reply to message #467387]

Fri, 23 July 2010 14:13

rkhatiwala
Messages: 178
Registered: April 2007

Senior Member

Thanks all for your replies.

I have Oracle client, and the excel file on the same machine. To connect directly via ODBC, do we need to make changes in TNSNAMES.ora or any other changes?

Thanks.

Report message to a moderator