|
 |
asp_databases thread: Create Downloadable Delimited File with ASP
Message #1 by andrew_bagley@e... on Thu, 25 Apr 2002 12:37:57
|
|
I have an asp web page which picks up data out of a SQL Server.
The items are MyDate, MyValue
The data is used to create a history chart of the data but I'd also like
to create a downloadable comma delimited (CSV) file of the data which can
then be imported to Excel. Can anyone give me some starting points for
doing this?
Thanks
Andrew
Message #2 by Greg Griffiths <greg.griffiths@g...> on Thu, 25 Apr 2002 18:51:49 +0100
|
|
just use the File Scripting Object to create a file and then create it :
write (MyDate & "," & MyValue & ",")
At 12:37 25/04/02 +0000, you wrote:
>I have an asp web page which picks up data out of a SQL Server.
>
>The items are MyDate, MyValue
>
>The data is used to create a history chart of the data but I'd also like
>to create a downloadable comma delimited (CSV) file of the data which can
>then be imported to Excel. Can anyone give me some starting points for
>doing this?
>
>Thanks
>
>Andrew
Message #3 by andrew_bagley@e... on Mon, 29 Apr 2002 21:02:19
|
|
Greg,
thanks for the lead. I'll take a look into "write". Sorry for the time to
get back on this, I couldn't seem to get onto the site on Friday.
Regards
Andrew
> just use the File Scripting Object to create a file and then create it :
write (MyDate & "," & MyValue & ",")
At 12:37 25/04/02 +0000, you wrote:
>I have an asp web page which picks up data out of a SQL Server.
>
>The items are MyDate, MyValue
>
>The data is used to create a history chart of the data but I'd also like
>to create a downloadable comma delimited (CSV) file of the data which can
>then be imported to Excel. Can anyone give me some starting points for
>doing this?
>
>Thanks
>
>Andrew
|
|
|
View Cart
