Link to home
Start Free TrialLog in
Avatar of draeside
draesideFlag for Afghanistan

asked on

Is it possible to update SQL table from Excel?

Is it possible to update SQL table information directly from excel? I would like to be able to update, insert and delete values and rows in my spreadsheet and for the changes to take effect in the back-end table interactively in the same way as imported data is updated upon refreshing my spreadsheet.
Avatar of Brad Sims
Brad Sims
Flag of United States of America image

The simple answer, yes.  But as far as 'interactively' I would get the information right and have a macro run after you're sure everything is ok.  You also need to have these permissions on the SQL Server.

What is your experience level with VBA?
Avatar of draeside

ASKER

I am a VBA beginner but have experience in other programming languages and pick things up fairly quickly. I have looked into SSIS and have managed to get this working however it would be better if I could achieve it via VBA/SQL.
ASKER CERTIFIED SOLUTION
Avatar of bromy2004
bromy2004
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial