PDA

View Full Version : Excel to SQL



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?

shorty
11-11-2009, 03:01 PM
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?

Bob Phillips
11-21-2009, 10:59 AM
You can connect to the database as you do now and issue SQL Insert or Update statements.