db contents to a .csv file

[jbgekko]

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

[jkh1978]

which database are you using?

[jbgekko]

SQL 2000

[jkh1978]

sorry I dont use SQL 2000 so I dont know.

[westmich]

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?

[jbgekko]

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

[jkh1978]

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?