I got this following scenario,...There are four tables COUNTRY, STATE, CITY, STREET...
And I have the excel file with the records of the above..possibly 2000 rows as of now....I used SqlBulkCopy to import the data to a temp table, lets name the table IMPO...