db contents to a .csv file

Does anyone have a script (or a resource they can point me to) that will dump the entire contents of a database into a .csv file?

I want to be able to point people to a URL that will open up the .csv file in Excel...

Thanks for all help in advance!

jb

which database are you using?

SQL 2000

sorry I dont use SQL 2000 so I dont know.

I don't think the database you are using has any bearing on your question.

You'll need to query your database and loop through the recordset writing a line of text for each record.

Are you using ASP?

I'm using ASP- but I am just learning it. Most of my experience thus far has come from modifying existing scripts...

All you need to do is open a file, do a select on all your data, and save it to a file, delimiting each field with a ",".

I dont know ASP so I cant help you out. I've used mysql and a PHP script I wrote to do something similar to what you need.

Do you want this done once, or done dynamically?