SQL2000 VBS Select

this could help you.

http://msdn.microsoft.com/en-us/magazine/cc301942.aspx

you can find one simple example at

http://www.edugeek.net/forums/scripts/8363-vbscript-sql-server.html

Nah - i need a sample script to put into a vbs file... very long story as to why, but to cut it short - i needs it to be this way as its part of something bigger

1 single pop up message with the data of those 2 columns for ALL the rows at once?
or
1 pop up message for each row, ie popping up all the time until all rows have been processed?

anyhow, what exactly is the code problem?
what can you do already? (note that EE is not a rent-a-coder site)

1 popup for each result returned...

I just need a framework which i can add my code into

I see. anyhow, I have to repeat:

anyhow, what exactly is the code problem?
what can you do already? (note that EE is not a rent-a-coder site)

The exact problem is that I need to extract some data from a table on an SQL server, manipulate it and then stick it into a different data form.

I have managed to code the part that will manipulate stuff once its into a variable and then put it up into the spreadsheets and documents and such like.. its just getting the data from the sql server to begin with I can't do.  I've been working on it for 3 days, but SQL isn't really my area at all

Fantastic Answer - Thankyou :)