jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Dynamic table creation based on excel template. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Dynamic table creation based on excel template." Watch "Dynamic table creation based on excel template." New topic

Dynamic table creation based on excel template.

Jigar Naik
Ranch Hand

Joined: Dec 12, 2006
Posts: 761

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.

Jigar Naik

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

Yes. Oracle supports creating a table through JDBC. Assuming your user has permissions to create a table of course.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link: http://aspose.com/file-tools
subject: Dynamic table creation based on excel template.
It's not a secret anymore!