ma701ss (5/27/2015)
Hi,I have two columns in an Excel spreadsheet: productid and colour.
These columns are populated with values, e.g. '123' and 'Red'.
I have about 200 rows and want to insert the colour values into rows in my SQL Server 2014 database where the productid matches.
What is the simplest way of doing this?
Thanks,
ma701ss
Quick suggestion, use the Import and Export Wizard, right click on the database in SSMS Object Explorer -> Tasks -> Import Data.
😎