maxhayden
11-05-2009, 02:23 AM
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?
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?