Hi,

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.

Hi

Probably the best way to do this is to reference MS Active Data Objects from your module. You could use ADO to run SQL queries from your spreadsheet...you could also use Insert statements ect. I guess the challange here is the logic to pick the correct data to insert and update.

I could send u a sample Module that use ADO to query a DB and write it to the spread sheet. Let me know if this will be of any help

Marnus