Skip to Main Content
  • Questions
  • Need to read file from Local client system

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, UTHAMASELVAN.

Asked: March 05, 2020 - 5:21 pm UTC

Last updated: March 06, 2020 - 3:29 am UTC

Version: 12c

Viewed 1000+ times

You Asked

Dear Experts, Good day to all, I need a help, I want to read a file from Local client system, For example, I have a stored a Excel file in Client Local system in D:\file\details and file name is data.xlsx, from the file I have stored, Cell A1 is Name and B1 is City, In Oracle apex form page, If I click a button, system need to read the file from the mentioned directory and put it the word in respective table, Can we do it in Oracle. If we can do it, Please guide thanks in advance.

and Connor said...

APEX will let you upload a file from the client file system, but to my knowledge it must be user-initiated, because the browser must ask the OS layer for that interaction.

Jeff Kemp has a nice writeup on this here

https://jeffkemponoracle.com/2016/08/file-upload-improvements-in-apex-5-1/



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.