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??!?
Member
14 Points
67 Posts
Excel Help Please
May 26, 2010 06:02 PM|fadi-ft|LINK
hello there,
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:
thanks,
excel
Member
465 Points
162 Posts
Re: Excel Help Please
Jun 01, 2010 06:27 AM|subalakshmi.ms|LINK
Hi,
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.
Suba
Cognizant