CODEWITHSUNDEEP
sql-serverexcel
Ahmed Mohammed Abdel Kader
Ahmed Mohammed Abdel Kader

Reputation: 149

Automatic Update from Excel to SQL Server

I need to load the data from excel to a table in SQL Server 2008 and automate the updates.ie., If there is a new record or an update to the existing record in the source excel it should automatically update the SQL Server Table.

Is it possible, if yes how?

Any ideas or suggestions would be helpful.

I Use: Excel 2013 - MS SQL

Upvotes: 0

Views: 1968

Answers (2)

JohannesGbg
JohannesGbg

Reputation: 101

I've created an Excel Add-In that will insert new rows in Excel into the SQL Server table and also update changes in existing rows in Excel into the SQL Server Table.

It is a commerial prodcut, but if it is a time limited job, you can use the full functional trial for free (and if you need, just send me an email and I'll extended the trial for you).

You can download the Excel AddIn from http://sqlspreads.com/download-sql-spreads/

Upvotes: 1

dtell
dtell

Reputation: 2568

I would check if something has changed on your excel worksheet and if so insert it into your database table. You can handle all of these steps using VBA.

Let me know if you need further information how to handle database connections via VBA.

Upvotes: 0

Related Questions