Excel to SQL

I've written a mini system in excel that people are using to record results via a userform.

This mini system was only meant for a small group of users, but other departments have started to adopt it.

I don't have the programming knowledge to develop an html user interface at the moment, but I would like to get this data onto an SQL database, rather than sitting on an excel spreadsheet.

Can I put some code in the excel macro that when the button is pressed, it sents the data to SQL as well?


I have pulled information from a database before using VarSQL = "SELECT......

Any ideas?

Hi, search for the post:
"This is how to write into SQL db table using excel VBA" by v.vasquezsj, submitted 07-23-2008
in this forum (sorry, can't post the link).
Maybe this could get you started?

You can connect to the database as you do now and issue SQL Insert or Update statements.