• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dynamic table creation based on excel template.

 
Jigar Naik
Ranch Hand
Posts: 762
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34218
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes. Oracle supports creating a table through JDBC. Assuming your user has permissions to create a table of course.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic