Home » SQL & PL/SQL » SQL & PL/SQL » Reading Excel File columns
Reading Excel File columns [message #408216] Mon, 15 June 2009 06:05 Go to next message
lollybanty
Messages: 1
Registered: June 2009
Junior Member
Hello,

i want to read the columns of an xls file, and a dbf file.

is this possible with plsql?

kindly help.
Re: Reading Excel File columns [message #408220 is a reply to message #408216] Mon, 15 June 2009 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you can find a procedure for this on the Web but I don't any that does it and I doubt anyone publish such a useless stuff.
Save your file in csv format.

What is a dbf file?

Regards
Michel
Re: Reading Excel File columns [message #408223 is a reply to message #408216] Mon, 15 June 2009 06:43 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You can use Oracle Heterogeneous Services for just this thing - it will allow you to select from each page of the spreadsheet as though it were a table viewed across a database link.

There's a good guide on how to set it up to work with Access here. All you need to do to change it is to make the ODBC connection point to the Excel spreadsheet rather than to an Access database
Previous Topic: insert in seperate columns depending on data
Next Topic: Dynamic crosstab script
Goto Forum:
  


Current Time: Tue Aug 22 19:50:54 CDT 2017

Total time taken to generate the page: 0.09420 seconds