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