Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 18, 2012 06:54 AM by Sharon59
Dec 18, 2012 06:29 AM|LINK
I have a requirement where in I have to upload all excel data into a table in sql server database. Also while doing this I have to check for dulication.
Ex: Say I have Firstname, Lastname and Email in Excel. I have to import same data into my table in Sql Database but EmailID shouldn't have existed before.
Dec 18, 2012 06:35 AM|LINK
use SQL DTS or SSIS and import email column only from excel file
Dec 18, 2012 06:54 AM|LINK
Workbook workbook = new Workbook();
workbook.LoadFromFile(@”D:\Work\My Documents\Sales Report.xlsx”);
Worksheet sheet = workbook.Worksheets;
Code from this post: