Hi,



Is it possible to generate a file from recordsets shown on an asp by using

asp?

On my asp page I can search for a record or several records and I would like

it to be able to put the information of that record/those records in a file

(maybe excel) and save it to the harddrive.

Does somebody know if this is possible with asp/can somebody push me into

the right direction?



Kind regards,



Carolien

Yes, you can.... lookinto using the FSO (FileSystemObject), or if Excel 

is installed on the webserver, you can instantiate Excel and dump the 

records to it direclty with the Range command... it accepts an ado 

recordset as a parameter..



Tomm



> -----Original Message-----

> From: Carolien Latupeirissa [mailto:clatupeirissa@h...]

> Sent: Tuesday, March 20, 2001 7:04 AM

> To: ASP Databases

> Subject: [asp_databases] Generating file from recordsets.

>

>

> Hi,

>

> Is it possible to generate a file from recordsets shown on an asp by 

using

> asp?

> On my asp page I can search for a record or several records and I

> would like

> it to be able to put the information of that record/those records

> in a file

> (maybe excel) and save it to the harddrive.

> Does somebody know if this is possible with asp/can somebody push me 

into

> the right direction?

>

> Kind regards,

>

> Carolien

>

>

> ---

> SoftArtisans helps developers build robust, scalable Web applications!

> Excel Web reports, charts: 

http://www.softartisans.com/excelwriter.html

> File uploads: http://www.softartisans.com/saf.html

> Transactional file management: http://www.softartisans.com/saf1.html

> Scalability: http://www.softartisans.com/saxsession.html

> ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html




> $subst('Email.Unsub')

>

>