dimanche 28 juin 2015

Updating SQL Server Columns From A Spreadsheet where a column in sql match a column in MS-Excel

I have a table in SQL Server with 5 fields a-e with a as key field. a-e has rows/values/data. I altered the table by adding two new column f,g, they are added but empty. Now I have an excel spreadsheet containing the rows a,f,g with data in them. Now Can I update my sql server table from the spreadsheet where a(excel sheet) matches a(sqlserver table). Thank You.

My Environment: SSMS 2012. VB.NET 2013 Professional. MS-Excel 2010

Aucun commentaire:

Enregistrer un commentaire