upload excel file into database
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.