upload excel file into database

[bhasker4]

Hi ,

i have mulitple tables and multilpe excel files,i need insert excel file data into table . The table must be select based on the excel file data that means excel file schema and data base scehma must be match. if both match then we have to insert the excel file data into table.
peresntly i am able to read excel file and data types of the columns,if first row contain data then i able to decide which table i have need insert ,problem is when there is blank cell in the first row at that time i am unable to decide which table i have to insert into which table

Please help me ,any one.

thanks,
Bhasker

[tim]

Welcome bhasker4, to Java Forums! :D

Recently I also imported data from excel documents into my database using Java. I read the spreadsheets using CSV and string scanning. I'm guess that you are trying to import the data by dynamically assigning a table to a spreadsheet depending on the data types. What I would rather do is to hard code which spreadsheet is for which table. The main problem with your approach is one we also get in OO programming. Signature ambiguity. For example, if you have two spreadsheets:

Vehicle(name : string, kilometers : integer)
Person(name : string, age : integer)

Which spreadsheet goes to which table? Rather code it explicitly. Or maybe, you can get professional software to automate this for you.

Good luck bhasker4. ;)