draeside
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What is your experience level with VBA?