I am making a form to import excel sheet from local computer to azure sql database easily.
i am using help of this topic for this:
http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx
i have made The ID as : Identity, Not Null.
As in my Excel sheet data the ID column is empty, as normally i used to integrate whole excel to sql db so it auto generate, but its waste of my time.
So i want to ask in order to make it successful in case i have no ID numbers for my data in excel file and have Not Null at azure sql db and want to auto generate ID on sql server db after the data that is already on the sql server db.
Because the table where data will be stored is having like already 142302 records and i want to generate my uploaded excel file to there and numbering automatically for ID as 142303, 142304 .... So on. I hope you guys understand what i am talking about.
Please guide a bit..