Burim, I had written an app to import excel files. That was some 3 years ago, so I no longer have the code. I did a google search for "C# import excel file into sql" and I found the same link I had used to write the code some 3 years ago. The link: http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx[^] I recommend you use this link to do the following: 1) SQLBulkImport the Excel file into an import table (a table in the same database but that is only used for this purpose) 2) Call stored procedure that grabs the needed data from the import table and updates whatever table(s) you need to update. In my case, I had a Unique partNumber, too, so I would A) Mark records in my primary table as "inactive" (I use a tinyint with 1=inactive and 2=active) that were no longer in the import table B) Add new records from the import table into the primary table. C) Update records in the primary table with changed values in the import table (usually the description and price). Hope this helps.
ASP ~ Apple Simply Performs