Excel VBA to SQL & back to VBA
I am trying to use Excel VBA as a simple front end to my MS SQL2000 DB. I have developed allot of tools in Excel and it would be easier to maintain these and pass data from excel to SQL and back.
What I am trying to do is the following:
Request data from SQL ( have been playing around with SQL.Request but no luck so far)
Send data to SQL
and create a new record.
If someone could help it would be highly appreciated.