import excel data into different database tables

Hi Unnam Nageswara Rao you can initially dump all the data into temporary table as Stefan Helzle  said, Then build couple of stored procedures using insert and update statements, run these procedures once the data is imported in to temp table. post running the stored procedures and populating the data into different tables, Delete the temporary  table using another stored procedure and again import data into temp for next set  of back.

Hi Unnam Nageswara Rao you can initially dump all the data into temporary table as Stefan Helzle  said, Then build couple of stored procedures using insert and update statements, run these procedures once the data is imported in to temp table. post running the stored procedures and populating the data into different tables, Delete the temporary  table using another stored procedure and again import data into temp for next set  of back.