Excel to database using java
I have received the requirement for reading excel spreadsheet and export its data into our SQL Server database. The spreadsheet contains 3 workbooks, each one has huge rows with around 20 to 30 columns. I would like to determine how to read excel data to database and what could be the best approach to implement the functionality. The thing is that in each row some columns has to go different table and some columns to its associated tables. If data is not found in excel for particular record, then we make sure not null constraints table are also ensured.
Do reply the best solution for this approach.