We are developing one package in oracle form builder 6i with oracle 9i as back end.Our form contains a button and a text item which reads the file name with location of an Excel file .While pressing the button we have to take the data from the above excel file into one oracle table. Format of the excel file and structre of the oracle table is already defined.We are using windows XP professional platform.
Pls advise how to take data from excel to oracle table.
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.