RE: Use ASP/SQL to export to Excel?

Hi Mike,

I created as ASP page to do something like this for a client.
Highlights as follows:
- Used SQL to get the records I wanted into an ADO recordset.
- Used the File System Object to create a file on the server
and to write tab-delimited records from the recordset to the
file.
- Used SA-FileUp to download the file to the user's PC.
- Used the FSO to erase the file from the server.

HTH ... let me know if you need more info.

David Clapper

>--- Original Message ---
>From: Mike Taylor <lonewolf(at)one.net>
>To: hwg-techniques(at)hwg.org
>Date: 4/17/01 6:53:56 AM
>

>I have an ASP page written in VBScript I've put together for
some in-house
>reps to display data from a SQL database.  This data is generated
on the
>page in, of course, HTML format.  I've gotten requests about
clicking on a
>link that will generate the same info in Excel format.
>
>The only way I know of to do this would be to run a SQL job
that exports
>to that format, but I see no way of triggering that from the
client's
>machine.
>
>Is there another way to do this?
>
>Thanks,
>Mike Taylor
>
>
>

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA