import excel data into different database tables

Not directly. My best practice to import Excel, is to first do a raw import into a temporary table, ignoring all the column names and data types. Then run a stored procedure that does the data typing, and copies the data to its final place.

Hi [mention:52de0ce478ae4a25be2fbff46609a4fb:e9ed411860ed4f2ba0265705b8793d05] you can initially dump all the data into temporary table as [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  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.