Update SQL Server Table data using Excel

nauna

SOLVED CLOSED ACTIVE ANSWERED
User: nauna
Posted: on Oct 26, 2014 09:29 AM
Forum: SQL Server
Answer: 1
Views: 2714

Hi,

I have sql server table, I have export the data to excel through sql server management studio export tab. Now I have made some data changed in excel file and i want to import it back to my sql server table but i do not want to insert it i want to update the existing record in sql server table.

Please guide

Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 2

Reply
ANSWER
User: Mudassar
Replied: on Oct 29, 2014 03:33 AM
Report

You will need to delete the table data and then import the data from Excel

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Update SQL Server Table data using Excel

Company

Explore

Follow us

Contact Us