I have an excel sheet of product details. I have to import this while insert and update in my database if details already exist then update it. I m using visual studio 2010 tier architecture method.
Is there any API or any solution to solve this task.......please
Thanks in advance
Loading
Rahul PrasadPosted Nov 17, 2014, 4:13 AM
https://http--stackoverflowzx-com.proxee.co/questions/22797917/import-excel-xslx-file-into-sql-server-difficulty-in-updating-table
http://janewdaisy.wordpress.com/2011/11/29/c-export-data-from-excel-to-datatable/