Oracle 11g - select rows from excel file

[cuetzpalin]

Hi,

How would I select rows from an excel file if I were to place the excel file in the same directory as the Oracle DB?

I have a process where somebody send data in excel via email. I'd like to know if it's possible to drop the excel file in a directory and execute a script than can read the data directly from the external directory.

Please advise.

Thanks!
John H.

 

[LKBrwnDBA]

1) Use VB script to load into Oracle.
2) Save the Excel spreadsheet as "delimited" (csv) file and load into Oracle using SQL*Loader or external table
3) Use MS Access to link Oracle tables, open Excel file and code TSQL or VB program to load into database.
4) Buy 3rd party software to do it.
-- Or --
Check out these options.




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[cuetzpalin]

Hi,

I'm looking more for an example on how to use external tables where the external table being an excel file or csv file. If you could provide a step by step on how to do this or lead me to a good reference site I'd greatly appreciate it! THanks in advance for your help!

 

[LKBrwnDBA]

External tables can only be "flat" files, not Excel format files.

Did you look at the Oracle® Database SQL Language Reference to learn about external tables?




----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[cuetzpalin]

Thank you. I'll take a look at the link...