Last post Jun 01, 2010 06:27 AM by subalakshmi.ms
May 26, 2010 06:02 PM|fadi-ft|LINK
I am writing code to import data from excel file and insert data into sql db table, i am using Bulk Copy, but i have a problem that in bulk copy i can't compare data between the two sources, such that i did not find anyway except empty the table and re-insert
all data with new data fronm excel file, anyone have any idea about any sol to this??!?
this my simple code:
xlDataReader = xlCommand.ExecuteReader()
bulkC.DestinationTableName = "Students"
Jun 01, 2010 06:27 AM|subalakshmi.ms|LINK
You can push the excel data and sql server Table table into two seprate data tables, then you can compare and update your sqlserver table.