Export to CSV

Report · Apr 23, 2008

I have a page with a recordset that I want users to be able to download as a csv or xls file. I am usins ASP/VBScript and data is in an access database.

I have developer toolbox and can create and XML page with the data, but I need it to download as csv or xls. Can someone point me in the right direction. My old Interakt extinson had the Export as CSV function but I don't see it here. -Thanks

Report · Apr 23, 2008

>I have a page with a recordset that I want users to be able to download as
>a
> csv or xls file. I am usins ASP/VBScript and data is in an access
> database.
>
> I have developer toolbox and can create and XML page with the data, but I
> need
> it to download as csv or xls. Can someone point me in the right direction.
> My
> old Interakt extinson had the Export as CSV function but I don't see it
> here.
> -Thanks

http://www.communitymx.com/abstract.cfm?cid=1C290

Report · Apr 24, 2008

If you're using SQL Server you could also set up a job that runs a DTS which
exports the query to a file on your server. You could then use sp_startjob
in a Stored Proc to run the job.

"Ken Pollard" <webforumsuser@macromedia.com> wrote in message
news:funrq7$p3l$1@forums.macromedia.com...
>I have a page with a recordset that I want users to be able to download as
>a
> csv or xls file. I am usins ASP/VBScript and data is in an access
> database.
>
> I have developer toolbox and can create and XML page with the data, but I
> need
> it to download as csv or xls. Can someone point me in the right direction.
> My
> old Interakt extinson had the Export as CSV function but I don't see it
> here.
> -Thanks
>

Report · Apr 24, 2008

Ted Dawson wrote:
>> I have a page with a recordset that I want users to be able to
>> download as a
>> csv or xls file. I am usins ASP/VBScript and data is in an access
>> database.
>>
>> I have developer toolbox and can create and XML page with the data,
>> but I need
>> it to download as csv or xls. Can someone point me in the right
>> direction. My
>> old Interakt extinson had the Export as CSV function but I don't see
>> it here.
>> -Thanks
>
>
>
> http://www.communitymx.com/abstract.cfm?cid=1C290

Now that is a cheap way to do it, most impressive! Another Tom Muck
masterpiece.

Steve