Task :1) Browse should open a dialog box window for user to select an excel file on his local machine. Once the name of file is on the ticket item file name, the upload button should load data of this file into a database stage table.
2) Host being called from forms u .Once it reaches server it is easy to load in DB via forms
3) File transfer should happen automatically when user presses the button on form the code in the button should make use of host command and fire command to move the file.
version :-FORMS10g , OS - XP
Have you tried searching the web? There are numerous examples of how to read and Excel file into a Form. Here is just one, for example: WebUtil: How to Read an Excel file into an Oracle Form . This example can easily be modified to write the file to a table versus displaying it in the form. Or...you could simply read the file into a base table block and use standard Forms Commit processing to save the data to your table.