How to write an asp script storing the result from a query in a CSV text 
Author Message
 How to write an asp script storing the result from a query in a CSV text

How to write an asp script storing the result from a query in a CSV text
file ?

Hello,

Generally the resutls from a query are sent to an HTML page
I would like to store them into a text file with the CVS format (; or ,)
The problem lies in the way to format the data.
Can somebody help me ?

Regards.

Jean-Marc PHILIP



Mon, 15 Sep 2003 03:59:44 GMT  
 How to write an asp script storing the result from a query in a CSV text
Jean-Marc PHILIP says:

Quote:
>How to write an asp script storing the result from a query in a CSV text
>file ?

Not too tough.
Response.Write your data separated by commas.  End each line with a
Cr/Lf.  Depending on what program you'll be importing the data into,
you may need quotes around string data.

Changing the Response.ContentType to "text/csv" should make it easy to
work with, as well.

----------
Randy Hunt
MCP+I / MCSE

visit
www.wshscripting.com for WSH scripts
www.serverscripting.com for server scripts



Tue, 16 Sep 2003 13:21:50 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. DBCombo Initially Blank

2. Q: FindKey equivalent for dBASE indexes based on expressions

3. How to write an asp script storing the result from a query in a CSV text

4. How to write an asp script storing the result from a query in a CSV text file ?

5. Script to parse Outlook survey results to a .CSV file

6. No current record

7. BP7 : internal error on Win2000 ?

8. D3 : How to free the resources... NEED SOME HELP!!

9. Shareware equivalents to Infopower DBGrid?

10. store a query result in a database???????

11. Writing ActiveX results to ASP page.

12. Store asp result on server

 

 
Powered by phpBB® Forum Software