I have an Excel sheet,sheet1 in which First row is termed as Reimbursibles. Under this there are 10 rows.I.e its remursible data.
Then after keeping one row blank I have invoice data. Under this i have 12 rows. ie this is invoice dtaa.
I want to import reimbursible data in one SQL server 2005 table and Invoice data in another table.
I am able import excel sheet data using Sqlbulkcopy in the web application. But this will import data from the whole sheet into one table.
As explained I need to import two sets of data into two different table.
Please help.
Thanks in Advance.
