use VB Script to output search results to an .csv file or Excel Sheet

[gchaves]

Greetings!

I am using an ASP page w/ VBScript to query a database for certain records. Once I find the records, I would like to output, or export, the result set to either a .csv file that can be opened in Excel or directly to an Excel sheet. Is there a simple script or method that someone could show me that would do this? Or can you direct me to a web site that I can look at? I am using an Access2000 database...if that helps.

I would be most appreciative!

Thanks...G

 

[johnwm]

faq222-2244 will give guidelines on forum usage. This is VB5/6 forum

ASP = forum333
VBScript = forum329

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

Essex Steam UK for steam enthusiasts