how to insert the values from excel sheet into a table. that is if we provide an excel sheet as an input, a table should automatically created based on the number of coloums in the excel sheet.
There are tools such as xlsql that allow you to treat Excel docs as a JDBCDataSource, from there you just need to transfer from one to the other. I'm not aware of an automatic way to do it though.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
