SQL to Excel And Back RRS feed

  • Question

  • Hi,

    I want to swap some values of two columns in a database. To do that I did by exporting tha database to an excel file using SQL Server Import And Export Wizard. Then made the changes in the excel and import it back to the SQL database. But then when I checked the SQL database, it had two sets of values, that is the values from before and the values from the excel. So how can I do this the right way, that is export from sql to excel and back for updating the existing database. I am using SSMS 18. Thank You. 

    Friday, September 25, 2020 8:46 AM

All replies