I need to import excel file into Oracle database through java but the structure of the excel file is not predefined. For Ex : There can be 3 columns in the excel file and next time there can be 5 columns in the excel file.
So is it possible to create a database table through java based on the Excel file. The file with new excel template will have different file name.
so if i have the excel file with the same name i need to insert the data into the exiting table otherwise i need to create a new table.
Is it possible ? if not can anybody suggest me the alternative for this kind of requirement. For the new excel file i can select the columns which i want to import, their datatype,length.