Insert or update SQL table based on values in Excel

DoubleD

New member
Joined
Dec 13, 2013
Messages
1
Reaction score
0
Points
0
Hi,

I have a SQL 2008 R2 database with a table that holds financial budget information. I also have an Excel 2010 spreadsheet that has the same structure as the SQL table. I would like to add a button to the spreadsheet that would either update the SQL table or insert new data to the table based on the data in the sheet (if the data exists, it must update, if not, it must insert)

I have done nothing so far and would greatly appreciate assistance from scratch on how to set this up.
 
Back
Top